You need to call DelimitedSplit8K (not dbo.Table1) as I did. Find it in the link I provided.

Shadab Shah (9/2/2012)

---

But that means i have to write update 31 times....

Why don't you just use UPDATE (if all 31 rows are present) or MERGE (if they are not)?

Let me explain a little further about the CROSS APPLY.

CROSS APPLY (

VALUES (Column1a, Column2a, Column3a, Column4a)

,(Column1b, Column2b, Column3b,...

You didn't say what's in CLocation.Text. Is that also a delimited string with the same number of values? Or perhaps just a single value? Or some combination?

Try changing:

AND

companyid IN(@CompanyID)

To:

AND

companyid IN(SELECT item FROM dbo.DelimitedSplit8K(@CompanyID, ','))

Where DelimitedSplit8K can be found here:

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Dwight617 (9/2/2012)

---

Sorry dwain .. data

INSERT INTO [Table]

SELECT 1234, 1, 'True', 'False', 'False', 2, 'False', 'False', 'False', 3, 'True', 'True', 'True', 4, 'False', 'False', 'False'

One other complication, looking to filter...

Like this perhaps?

DECLARE @DateTo DATETIME = '20110330', @DateFROM DATETIME = '20100330'

,@CenterNumber INT = 200

SELECT

----- FileHeader ------------------------------------------------------------------

(SELECT

CONVERT(VARCHAR(16), GETDATE(), 120) ...

I don't know if this is any lighter or better performing but it's another option:

SELECT *

FROM @NumberTable

ORDER BY RIGHT('000' +

REPLACE(

SUBSTRING(ItemNumber, PATINDEX('%[0-9]%',...

You're a bit scant on sample data, but we'll take a stab at it anyway. You can see in this example how to UNPIVOT single or multiple columns, so...

I moved the check for ExchangeLock process value = ID earlier in your CASE statement.

SELECT --DeadlockID,

COALESCE(PageLock.Process.value('../../@id', 'varchar(100)'),

...

Jeff Moden (8/31/2012)

---

dwain.c (8/30/2012)

---

I was initially expecting to have to use the standard rCTE adjacency...

Eugene Elutin (8/31/2012)

---

dwain.c (8/31/2012)

---

Eugene Elutin (8/31/2012)

---

If you really like the challenge, this one for you:

draw Mona Lisa using T-SQL (I remember I had seen assembler application which would print out...

Eugene Elutin (8/31/2012)

---

If you really like the challenge, this one for you:

draw Mona Lisa using T-SQL (I remember I had seen assembler application which would print out this one using...

Cadavre (8/31/2012)

---

Sorry dwain, but that smacks way too much of the stackoverflow method for answering questions. Since I hate the atmosphere over there,...