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...

gregory.anderson (4/21/2010)

---

And when I comment those two case statements out and just put 2 @False values for those fields the insert works fine.

Edit: It's getting wierder (is that a word),...

Since there is no error message posted I'd assume you need to set the collation for the MI alias used to compare against your subquery too:

and(RTRIM(LTRIM(MI.CLNT_MATT_CODE)) COLLATE SQL_Latin1_General_CP1_CI_AI NOT IN

(SELECT...