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 - 2002-03-27 : 11:15:41
|
| Augustin Prasanna writes "Hi,I have a requirement. i have a table called TblGoodsReceived. i need to generate a query such that it returns the sum of goods received between any 2 dates grouped by ItemId. Also, simulataneously, i need to display the received dates in a comma separated manner (for each ItemId). is this possible in a single query? which is the best way to go abt it other than using temporary tables & cursors?Sql Version : MS SQL Server 7.0Windows: Windows NT 4.0Thanks,prasanna" |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
|
|
augustin_p
Starting Member
21 Posts |
Posted - 2002-03-29 : 04:15:53
|
| Hi, Below is my table defn. Table : TblGoodsReceivedId: int (identity)RecdDate: DatetimeItemId: numericQtyRecd: numerici need to display total received qty for an item between any two dates and also received dates like in below formatItemId Qty Dates------- --- ---------01 200 1 Mar 2002, 3 Mar 2002, 5 Mar 2002Hope you got my point. i want to do this without using cursors.Thanks,prasanna |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Group By clause