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 |
|
jesus4u
Posting Yak Master
204 Posts |
 Posted - 2001-09-19 : 14:01:58
|
| Can I parse the DateAdded data inside this stored proc because the Dateadded has a time stamp which I do not want?SELECT dateadded, (sum(orderqty) * 2) AS 'Orders'FROM [Order] INNER JOIN Contact ON Contact.ContactID = [Order].ContactID Where DateAdded >= DateAdd(d,- 20, getdate()) and FirstName <> 'CMS'group by dateadded |
|
|
|
|
|
Parsing Stored Procs