Great post - I'm sure I'll be referring back to this often!

Great post - thanks for sharing - this just saved me a ton of time trying to figure out how to do this on my own!

I had a similar problem. Verify that the Data Source Type of the data source that your report is using is set to Microsoft SQL Server and not OLE...

Thanks for the great article - I thought that you did a good job of explaining how to use the row_number function and comparing its performance to subqueries.

Tim

That works great, Thanks!!!!!

I tried to use this on SQL2005 but every time I add the trigger, the trace ends without any indication of what caused it to fail. Has anyone got...