Looks like a job for DynamicCrossTab. See the related link in my signature.

Side note: If you'd like to see a coded sample based on your data please provide ready to...

I'm just guessing here but it seems like those are the seconds based on a start date (I don't know the startdate though, so just guessing...)

SELECT DATEADD(ss,1271782698,'19700101')

/*Result

2010-04-20 16:58:18.000

*/

Regarding PIVOT:

Would be great if it would be enhanced to handle more than just one column to be pivoted.

So, instead of just (BOL sample snippet)

...PIVOT

(

COUNT (PurchaseOrderID)

FOR EmployeeID IN

( [164], [198],...

Would you add the update sqlplan please? 😉

I hope it'll work...

Godd luck! 🙂

Did you consider using bcp with a format file based on your word doc definitions?

Sounds like the easier option...

Duplicate post (moved to SS2K8 forum for a vaild reason... ;-))

Continue here

Would you mind explaining why you have to have it as a RBAR (row-by-agonizing-row) process? Best would including some fake sample data so we can better understand your requirement...

Would you mind providing table DDL including some fake sample data and expected result?

Would help a lot folks like me that prefer to have something to play with / test...

Ok, let's try the following:

- after loading the PWDPermitConversionData2 table, add a clustered index on PWDPermitConversionDataID.

- after inserting into PWDPermitConversionErrors2, add a clusterd index on PWDPermitConversionDataID,RecordIndicator

- after inserting into PermitsInserted,...

Having multiple CPU and shared processing (as a short answer).

Regarding your prev. post: I'll have a look at it...

Are you sure you're at the right forum?

Error message looks like some Oracle stuff...

Before you get lawyers involved, make sure there is some paperwork supporting your position. At the minimum dunning letters/final demand including the statement that there will be no support nor...

Your requirement is a little strange...

Why do you want to query the XML version of an Excel file? Wouldn't it be a lot easier to use OPENROWSET to the...

Ok,

a few things you can change:

[PrevIssueDate]:

Don't do the comparison inside the CASE statement of the subquery.

Move it to the outer SELECT. Also, I don't think you need to do...