Yeah, but the OP got it wrong!

It does indeed look very pretty 😎

I'm going with the upgrade to 2008 and...

Not entirely, but I can see why you would say that.

Nobody here (except...

No.

It's overkill and inefficient for what the OP is trying...

Very creative.

Where would the following sort...?

1.4.1

1.4.2

1.5.1

1.5.2

1.22.1

1.23.1

😛

Chris Morris-439714 (7/13/2010)

---

Oh no, I knew I should have stayed at home today with this headsnake :doze:

This looks to me like a valid sequence with rules - note the position...

This site has just republished an excellent two-part article by R Barry Young on how to replace cursors in your code:

There Must Be 15 Ways to Lose Your Cursors[/url]

He did.

I took Chris' post as pointing out that...

Giving a column the IDENTITY property does not...

Or even:

WHILE EXISTS

(

SELECT *

...

Quite.

It's a knack 😉

That would work (and Chris would provide a recursive CTE solution)

Where should 1.2.10 sort, I wonder...?

This one uses a cursor:

DECLARE @temp INTEGER; -- Our random number

DECLARE @dummy INTEGER;

DECLARE curNullAppIDs CURSOR LOCAL

SCROLL DYNAMIC

...

For comparison purposes, this is one possible row-at-a-time solution:

-- A temporary table for demonstration purposes

CREATE TABLE #EventPersonInfo

(

...