Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-06-26 : 08:21:15
|
| Hey Sql Freaks.I was hoping to find this on my own, but I am not even sure what to look for.I am writing a report, it lists budget information for specific contract numbers.the report lists several contract numbers, the initial budget amount, a modified budget amount, used monies,committed monies and available funds.Basically I need to calculate the used,committed,available columns from the other columns.I have used correlated sub queries, but I cannot rely on the contract numbers to be unique(wish I could, but no).I have never used a cursor, just been avoiding them as much as possible, but is that the only way to really pull up all this computed data?Thanks for any help, I basically suck at t-sql. |
|
|
|
|
|
Is Cursors the only option?