nathan 7372 (2/26/2010)
Yeah I'm working with refunds so refund=amount. I have 222K rows of data which comes out to about 11K accounts. I will definatly be interested to see your query especially if it puts out the performance you claim. Thanks
Do you have a running balance column in your real table that you need to have filled in? If so, I need you to post the create statement including all indexes for the real refund table, please. It's important.
--Jeff Moden
Change is inevitable... Change for the better is not.