Sure - avoiding the JOIN in the code...

Here's a Q&D alternative from a TSQL grunt:

SELECT

Value,

Item

FROM (

SELECT

Value,

Item,

[Instances] = COUNT(*) OVER (PARTITION BY Value, Item)

FROM #t1

) d

WHERE Instances = 1

I...

Un-freakin'-stoppable. It will!

Please explain why, in a SQL Server 2008 forum section?

It's not at all clear what you are trying to do.

Are you attempting to insert a string into a Nvarchar(Max) column?

How are you...

What is the data type of this column which is causing problems?

Looks like Kingston's got the nail on the head here.

As a matter of interest, what is the aim of this operation?

The first action grabs everything in a string to the...

Can you please post the view definitions:

vMBlockstoFinal1, vMBlockstoFinal2, vMBlockstoFinal3, vMBlockstoFinal4

Thanks

Two suggestions

Run this part on its own: (select clientid from table where ...)

Post the whole sproc.

Ken@Work (9/22/2010)

---

I don't believe Case will allow me to do what I need.

As I said there will be many (100 plus) variables which some may or may not be used...

Mike Menser (9/22/2010)

---

I would think it would be more taxing at the server to write a loop, or create a temp table and insert all the values and then do...

It can be awkward to get all those pesky commas and brackets in the right place? Small price...

vevoda.ulath (9/22/2010)

---

...

Well, my intention is to write query for select data from #myTable using replacements from #replacements table, i.e. desired output is

Hope it's clear, thx...

vevoda.ulath (9/22/2010)

---

Yeah, not nice solution. Anyway, I'm stuck too to do such.

Something looking pretty useful was posted on other forum:

CREATE TABLE X_REPLACEMENTS (

string NVARCHAR(100),

replacement NVARCHAR(100));

INSERT INTO X_REPLACEMENTS VALUES ('abc','123');

INSERT...

Bob's made some excellent points there. In case you return to ask a few more questions - please do if you get stuck - here's a bit of code which...