It probably depends on the amount of data that you need to return, but a solution that worked for me was to generate the xml dataset in SQL (FOR XML...

Thanks for showing me a couple of other ways to do this. I particularly liked the UNION example to avoid using IF. I can already see a use...

I have a report that needs different regions of data.  Rather than having each region be a seperate dataset I created a query that combines queries for...

Here are some more details.  I need the Top 15 orders for EACH Employee.  I have done some testing and the correlated subquery runs much faster than a table variable...

I'm running into the same problem... only I can't use Max because I need the 15 most recent records for each EmployeeId.  The following query works in SQL 2005, not in...