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 |
|
Hpolanco
Starting Member
7 Posts |
 Posted - 2006-10-27 : 21:48:19
|
| The script is supposed to uniquely list each item for sale by name and show the quantity of each sold for a particular period of time.This is the code can any one help out and find the solution I know there are two problems but i don't know what can i do to fix it help me pleaseuse KTCselect b.ItemName, (SUM(a.Quantity))as "Count"from Order_Details a join Items b on b.ItemID = a.ItemID join Orders c on a.OrderID = c.OrderIDWHERE c.OrderDate < CAST( '11/30/2004' AS datetime ) AND c.OrderDate > CAST( '11/11/2004' AS datetime )GROUP by b.ItemName, b.ItemUnitPriceThank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
help please