I can't find it in BOL, but I think you're SOL. 😉

Best you can do is this, and it still means keeping the positions of the...

Lynn: Wait... are we disagreeing about something?

If so, don't mind us, Scott. Sidebar discussions are the only payment a volunteer ever gets.

Ewww....

Did the same people who wrote the first chunk of code design your DB ??

I provided the trivial data, but mine still works if they aren't in sequence. That was omitted from the original specs, so I didn't want to assume...

Lynn, doesn't this assume that all the duplicates are going to fall together in sequence?

Looking at the two little schema you supplied, I don't understand why the user ID is associated with a piece of equipment, rather than with skills. I would...

Tsk... I'll never understand what is wrong with a simple integer.

cast(min(cast(ID as varchar(50))) as uniqueidentifier)

I can give you a cross apply solution, but nothing will build #dupRawData as...

Scott, please note that I revised my original solution to cut down on the number of scans of your input table. It now creates a temp table...

This should work for you. I just revised this to break duplicate RawData into a separate temp table and index it. The original version using just...

Why so it is! Sorry. Good luck with implementing the Calendar table. You won't regret it.

Thank you SO much for posting up sample data. 🙂

I'm still not sure I completely understand your requirements. Can you add to your post what you would...

Been there, Barry. You get LOTs of sympathy and well-wishes. The good news is that it will all be over quickly. I mean that...

Morning, Alvin 🙂

Isn't that what I said? Must... drink... more ... coffee....

Isn't it beautiful outside this weekend? ...

The rows column would be the same.

Do you think if I went back and edited my post to remove the code, the Thread might forgive me?

And... my assumption about the...

I've done it many times.... and yes it is 😀

Mostly I've had to explain to someone why I favor running many reports against summary tables that are populated with totals...