>I'm not sure what DBMS you have but with Oracle it's pretty simple: >select distinct to_char(OrderDate, 'Mon yyyy') as mon, >sum(Volume) over(partition by to_char(OrderDate, 'Mon yyyy')) as t >from foo > > >On 1/23/06, won lee <[EMAIL PROTECTED]> wrote: >>
Running SQL server. Will try to run with it. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:193838 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
