Have you looked into the OUTPUT clause.  It sounds like that might serve your purposes.  It's available in INSERT, UPDATE, DELETE, and MERGE statements and allows you to generate a...

First, your table script is messed up.  I suggest you update it.

Second, ROLLUP has a very specific meaning, which is not what you want here.  Try searching on...

I don't have time to work on this right now, but I think that the answer will come down to density of the duplicates.  That is, it depends on the...

I suggest you read the following article on Packing Intervals.  It outlines a better approach to this.  You really need much more sample data for anyone else to...

The code sample is a recursive CTE (rCTE) and the WHERE clause is there to prevent infinite recursion, but this is a bad example to be following, because an rCTE...

The main reason that your procedure is slow is that you are using a CURSOR.  SQL is optimized for set-based operations, but the CURSOR forces it run for each member...

I hate it when people give you requirements in dribs and drabs. 

Drew