Try swapping:

PatIndex('%"%,%"%',THE_LINE)),

-- with this:

PatIndex('%,"%,%",%',THE_LINE)),

Note where the additional commas are to detect beginning and ending doublequotes.

I may have an alternative for you but it's going to be a busy day. ...

Cool, okay. Some of your other brief descriptions contain verbage that I have to translate in my head to think if I know what you're talking about. Are...

There was a longer discussion a while back here:

http://www.sqlservercentral.com/Forums/Topic840059-360-1.aspx#bm840576

Nonclustered indexes lookup off the clustered. Non-clusters shouldn't have any user_lookups, only the clustered will when the NC's have to go...

Andy,

For those of us un-hip in the new termonology, this is just basically environmental configuration usage, right?

For starters, I would recommend you double check the necessity of SAP. It's a unique product and it can be expensive to find technical support for it. There...

I've got a bit of a concern about this process. Specifically in your place-holder mechanic.

My concern there is that you you only want to replace the commas between the...

The For XML bit is slightly modified by me, but mostly is borrowed from here:

http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/

This code should do what you're looking for. First it normalizes the data so you...

Bhuvnesh (1/24/2011)

the usage of resources if fine as per the query design.but i want to avoid Clus index scan or its cost %....

You know... randomly... has anyone thought about getting their SQL Servers tweet accounts? I think that'd be the second good use for tweeting I've seen, the first being some...

Cool, that's awesome. And those...

Mohammed, so did I, but some of the background stuff I read regarding server licensing and CALs made me question it... was hoping someone had chatted up Microsoft recently...

To be clear here, because your data doesn't support your result directly, you want all the data in the list that's NOT defaulted to bid1/bid2/bid3...?

Nevermind, sorry, you answered this above,...

SJ, you mention the LUNs are dedicated, and that's normal... but are the physical spindles dedicated or are they shared to other systems so you can get a higher spindle...

Ron,

Only one problem, that pivots a comma delimited string into a multi-line table. He needs 1 row - delimited 1 row.

A quick and dirty solution would be a...

Are slots involved in the calculation for overlaps? IE: Do you always have 20 slots available and need to make sure that you don't use more than 20 at...