Viewing 4 posts - 1 through 4 (of 4 total)
Try it out....
select t1.sales_id, t1.cust_id, t1.sales_amt, sum(t2.sales_amt) as c from t_sales t1, t_sales t2
where t1.sales_id >= t2.sales_id AND t1.cust_id = t2.cust_id
group by t1.sales_id, t1.cust_id, t1.sales_amt
order by t1.cust_id
July 2, 2008 at 10:58 pm
#837595
See usage of SET ANSI_NULLS ON|OFF
June 25, 2008 at 5:27 am
#833819
I wonder if this one was to makeup the previous QotD:laugh:
June 19, 2008 at 10:29 pm
#831473
What does sp_decribe_cursor do? Has anyone seen such function or was it a typo :sick:?
June 17, 2008 at 10:22 pm
#830181