Thanks Jeff. Any improvements (performance tested of course!) will be integrated and all ideas are welcome.

Concerning credits...I'll go ahead and make sure the proper credit is applied. There's plenty to...

If a trigger is going to be used for something like this wouldn't it make more sense to use an INSTEAD OF trigger? Then to get even more granular the...

Thanks all for the feedback. Every environment is different so it's hard to anticipate what kind of loads such a process might need to handle. In my use it was...

Jeff Moden (8/3/2013)

---

Just remember that SET ROWCOUNT is a deprecated feature and, according to the 2012 deprecation list, is scheduled to go away in the next version of SQL Server....

I think the site is fantastic and comprehensive without getting too "techie." Especially since it is so code oriented in some sections I think sections related to coding need lots...

I prefer using SET ROWCOUNT @X where @X is the number of rows to display since it is compatible with all SQL versions. Using a variable with TOP(X) was added...

I don't have adventure works installed either, so will make a guess. Does this work?

USE AdventureWorks2012;

GO

SELECT

Name

,(SELECT DISTINCT

...

If you ever use dynamic SQL using the built-in system function 'sp_executeSQL' and try to use an OUTPUT parameter the function will not work unless you explicitly append the N'...

If you could give us some sample data in table form it would be a lot easier to help you.

I could be totally off-base, but my first thought is to...

With the assumption that you really do need to run a separate process for each type, then you will probably need to use dynamic SQL like this:

First the sample data:

IF...

[See stored procedure at bottom]

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL

DROP TABLE #TempTable

CREATE TABLE #TempTable (

[RowNum] INT NOT NULL,

...

dwain.c (7/29/2013)

---

I like it. I'm trying to think of a way to incorporate it in my signature.

Reminds me of the quote ChrisM...

Also...looking at the query plans and statistics, Dwain's solution is certainly more efficient if it satifies your requirements...

Dwain is a master of minimilism and his response is certainly more succinct than mine. But I'll post what I came up with before Dwain beat me to it. I...

pluto1415 (7/26/2013)

---

We would like to generate a report that shows the following:

SalesPersonA - Sales for Jan-June2012 - Sales for Jan-June2013

SalesPersonB - Sales for Jan-June2012 - Sales for Jan-June2013

SalesPersonC - Sales...