Posted by othellomy on 12/04/06 05:21

> with 50K rows, this takes about 5 minutes. However I have almost
> 9,000,000 rows of history. (15 years of 4 quarter sessions). If this
> build is linear, it would take 1.25 hours.

Maybe you should do a linear build if you can. Then you can add up the
counts into a variable. However, it's not a nice solution but it just
might work.

• Next in forum: query sql server using xml dynamically
• Prev in forum: Re: Update - can I do better statement?
• Thread view: Re: Update - can I do better statement?

[Reply to this message]