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 |
|
jabulani
Starting Member
2 Posts |
 Posted - 2011-06-03 : 06:36:14
|
| Write an SQL statement that will perform a daily sum aggregation on the field cost. It must only use costs that are associated with the follow items: Z001, Z002. The cost must also only come from division 1. Below is the example table that you will be retrieving data from:Costs• Receipt• Date• Item• Reason• Division• Costjwmabena |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-06-03 : 06:42:30
|
| See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=161371 |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-03 : 06:42:39
|
Homework?Where's that snipe icon? x2==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-03 : 07:31:40
|
| [sniped] gives you |
|
|
|
|
|
|
help