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 |
|
JJ
Starting Member
23 Posts |
 Posted - 2004-03-15 : 22:16:00
|
| Jeff,I have another question for you. Now how can I get other calculations all based on a month/year relationship into the same resultset? I need to generate a report and of course different ways of calculating totals but need to be combined to produce a report. Should I use a stored procedure and dump all the calcs into variables then some how feed that into a temp table? What do you think?Thanks,JJ |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-03-15 : 22:33:57
|
| Does that mean nobody else is allowed to answer ?Best if you keep these follow up questions in the same thread for contextDamian |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-03-16 : 09:02:31
|
| Dr., Dr., Mister MD....ooh can you help him, what's ailing him...Got a lot of specifics to work with Jeff...Good luckWhat no DDL, DML or sample data?Telepathy engine....engage....Brett8-) |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-03-16 : 10:31:33
|
| you need to give us some table structures and data, as Brett mentioned, and some specifics as to what you are trying to get. And also, how are you displaying this report to the users, using what technology (i.e., Excel, Crystal, ASP, Access, etc)? - Jeff |
|
|
|
|
|
|
|
|
Aggregates - Jeff