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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-09 : 11:24:29
|
Sophie writes "I'm working on Windows NT/SQL7.0, SP1.
I have to write a report using one table that contains the Car Movement details. My problem is that I have to get the subtotal for the moving days by Shipper, but the values in the "Shipper ID" field vary depend on the "Moving Type" and I need all types to calculate the moving days-- Don't ask me who designed the database, please!!!
I think maybe I can write a store procedure for it, but I've never done one before. Do I need a create a temp table for that? I'd really appreciate that somebody could give me some ideas.
Thanks a lot!" |
|
|
|
|
|
subtitute a field values while querying?