Sometimes things in this world don't need to be about work or business.  I love when daylight savings kicks in.  It's nice to walk out of the office and into...

There's only 154,000 rows. That's how bad my row by row cursor solution was. :crazy:

This is it below (with minimal tidy up)

SET NOCOUNT ON

DECLARE @customerID INT

DECLARE @gender CHAR(1)

DECLARE...

Thanks a million Jeff

Using your script as a basis, you turned a 26+ hour process into 32 second process.

This is the code I'm now using

-- Add Column for Sequential...

Thanks Jeff

I've created a test script below.

IF OBJECT_ID('TempDB..#customers', 'U') IS NOT NULL

DROP TABLE #customers

CREATE TABLE #customers

(

CustomerID INT IDENTITY(1, 1) PRIMARY KEY...