I wish MS would just make the changes, why should we have to depend on 3rd party vendors?

Some of the most obvious ones that should have been in QA long...

Also thanks to David!  I will try all three methods and let you know which performs best.

Brilliant Vasc!  Thank you!!!  I will try this today, I would expect it to perform much better then my current method using a cursor.  Thanks again!

Sorry - grouping is by location and item.  I need to remove the 2 weeks with the highest sales qty for each location/item combination.

I'd be intereseted to see some actual performance results.  In my mind, it doesn't make sense that a table variable used in this fasion is faster then a cursor.  A...

I agree 100%.  That article was silly, and obviously written in anti-microsoft fantasy land.  She makes no valid points - how can you complain that your workgroup edition CAL, which...

We have been using this idea internally for years in a winforms app.  Our base product is very soft and intelligent, allowing you to basically design the database and not...

Changing the curosr from fast_forward to static (they are mutually exclusive) resolved the issue!!!  The client claims that it worked fine up until last week, but this seems to prove...

??  I thought that the "fetch next" line right after the while loop begins is in the loop.  But two posters have said the problem is with the fetch next?  Can...

Very useful, keep up the great work!

I can give you our experiance in converting reports from CR to MSRS:  It has been simple.  The longest part is usually setting up and configuring the MSRS server.  We have one person...

Can I ask why you need it or what you are looking to accomplish?  Here is a good place to start:

http://www.nrf-arts.org/

There are several methods you could use (I usually use a .vbs), but here is one that uses all T-SQL.  Basically create a linked server, and then use openquery to...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_5pde.asp

Guess that should have been more obvious to me since we just switched to a multi processor server