No, I understand the problem and I have seen this solution before.

Uncommenting the loop returned the same results because the loop is supposed to run only once.

Please try this after commenting out this line:

--WHILE @@ROWCOUNT > 0 --Update until there's no previous group for any Client

I believe that you will find no difference.

Thanks for sharing! We did a similar workaround, except we created a configuration DB and normalized it, due to the complexity of our systems.

Thank you for sharing - I am a scripter, but I never realized (researched) that a proc was available for this.

Nor I. Great work!

You are bleeding edge with this - U-SQL seems to resemble a cross between T-SQL and Powershell, with a bit of DOSShell thrown in. I don't know when our...

Great article, Mike. Much better than the Microsoft documentation - all examples are TBD. Can't wait for the rest of it! Five celestials from me.

What about using the APPLY in the CTE?

hakim.ali (5/6/2016)

---

John Hick-456673 (5/6/2016)

---

Yes, it does -...

Yes, it does - it depends on...

Thanks for taking the time to write and post this, Paul. This was a very, very deep dive!

Paul Novelli (5/6/2015)

---

Good article. Thank you.

It's worth noting a little-known bit about cursors: They can be declared like any other variable. For instance,

Declare @MyCursor Cursor;

And subsequently SET...

Thanks, Chris.

Thank you, Jeff, and you, Jason. I've learned more from lurking on SSC than I did in my CS classes back in the day.

You two, Dwain Camps,...

spaghettidba (4/18/2015)

---

John Hick-456673 (4/17/2015)

---

spaghettidba (4/17/2015)

---

craig 81366 (4/18/2013)

---

I'm going to...