Sean Lange (7/10/2013)

---

Here is...

GilaMonster (7/10/2013)

---

The only thing that...

Jeff's way is probably faster, but I have a general purpose function called RN_MULTINOMIAL that you can use for this.

See the 2nd article linked in my signature.

Delete through a CTE thusly:

WITH Rows2Delete AS (

SELECT id, [date], rn=ROW_NUMBER() OVER (PARTITION BY id ORDER BY [date] DESC)

FROM Verification)

DELETE FROM Rows2Delete

WHERE...

mickyT (7/9/2013)

---

And in the category of just plain silly ... OVER (ORDER BY (SELECT 'I can''t think of anything better to put in here too

cause this to be a string...

Jeff Moden (7/9/2013)

---

Test Code...

DECLARE @BitBucket BIGINT

SET STATISTICS TIME,IO ON

SELECT TOP 1000000 @BitBucket=ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

FROM sys.all_columns ac1, sys.all_columns ac2;

SELECT TOP 1000000 @BitBucket=ROW_NUMBER() OVER (ORDER BY (SELECT 0))

FROM sys.all_columns...

Yeah! Probably should have used the Euro symbol instead. 😛

Thanks for the link Jeff. That is some pretty deep stuff.

You've got a SQL formatter? I'd like to hear about that!

As Alexander hinted at:

SELECT dt1=MAX(dt1), dt2, dt3, dt4, dt5

FROM #Something

GROUP BY dt2, dt3, dt4, dt5

ccmret (7/9/2013)

---

I am trying to get a EmpID where the PayID is not null. My problem is that an employee may have several EmpID’s. So I am currently...

Jeff and Gila,

Thanks for the clarifications. I take it you're saying that even with a MAXDOP 1 on the simple SELECT it doesn't guarantee row ordering.

My question was mostly...

reid.kell (7/9/2013)

---

No. In my scenario, Luis' routine correctly generates 5000 records; yours generates one. In my text file, each "record" spans 35 lines. There are 35 lines x 5000 records...

jralston88 (7/8/2013)

---

2. The supposed OS requirement before upgrading is Windows Server 2003, SP2. The upgrade candidates have Windows 2003 SP1 and Windows 2000 SP4. Is this a...

Or perhaps something like this:

WITH Regions (Region) AS (

SELECT 'north' UNION ALL SELECT 'south')

SELECT region=CASE Region WHEN 'north' THEN 2 WHEN 'south' THEN 3 END

FROM Regions