Thank You for the links and the schooling 🙂 Makes more sense now!

I try and not to be some copy pasta gangsta and learn what each item step does....

It's eating through 300,000 rows like corn now 🙂

BUT

I need to understand more on

DECLARE @Colslist VARCHAR(MAX)

DECLARE @Cols TABLE (Head VARCHAR(MAX))

INSERT @Cols (Head) ...

Yup it was forgot that this one was not in full 2008.. thanks again!!

fixed it with

insert INTO #t ([3Marketplace Order ID], [1Request Item], [2Marketplace Product], [11Item Date Closed],[10Date Due])

VALUES ('WS849369','WPS.QA1','Wintel Package Request','2010/03/29 03:54:50.000','2009/10/14 09:15:32.000')

insert INTO ...

Somthing odd happens though

when running on one SQL 2008 Server everything works fine, when running on another,same version, I keep getting a

Line 3: Msg 102, Level 15, State 1:

Incorrect...

Thank You!!!

I see I need to do some reading 🙂

3Marketplace Order ID,WPS.GenerateWrapID.Auto,WPS.Notify.Auto,WPS.Prod Entitlement,WPS.PublishToProd.Auto,WPS.QA1,WPS.QA2

WS849369,2010/03/29 04:20:59.000,2010/03/30 18:59:14.000,2010/03/30 18:59:13.000,2010/03/29 04:21:01.000,2010/03/29 03:54:50.000,2010/03/29 03:55:36.000