| Help !!! URGENT PLEASE. [message #395] |
Sat, 09 February 2002 09:13  |
jack
Messages: 123
Registered: September 2000
|
Senior Member |
|
|
Hi All,
I have a current BANDWIDTH table contains as below
SVCTYPE MAXCELLRATE MINCELLRATE UNITSMAX UNITSMIN
------- ----------- ----------- -------- --------
1 3000 0 3 1
1 10000 0 2 1
1 3500 0 1 1
3 3000 3000 1 3
3 1200 12 2 2
3 5000 10000 3 1
In SVCTYPE column.
1 = CBR (Constant Bit Rate)
3 = ABR (Available Bit Rate)
In UNITSMAX/UNITSMIN columns.
1 = bps
2 = Kbps
3 = Mbps
I need to do the sum of MAXCELLRATE for CBR and the
sum of MINCELLRATE for ABR that will not exceed
total bandwidth 130 Mbps (130.000000 bps).
Thanks in Advance.
Jack
|
|
|
|
| Re: Help !!! URGENT PLEASE. [message #407 is a reply to message #395] |
Mon, 11 February 2002 04:52  |
pratap kumar tripathy
Messages: 660
Registered: January 2002
|
Senior Member |
|
|
see these statements, it may give u some idea.i am not sure what is ur objective . sorry if i have messed u up.
--CBR
select sum(maxcellrate*power(1024,unitsmax-1)
from bandwidth
where svctype=1
--ABR
select sum(mincellrate*power(1024,unitsmin-1)
from bandwidth
where svctype=3
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
