IKIK (5/18/2009)

---

As for dynamic SQL, it's just years of bad experience starting with inability to verify syntax and ending with injection attack scare. I don't want to debate the cons...

IKIK (5/18/2009)

---

Thank you all for excellent information! Concerning dynamic SQL, I just can't sleep at night knowing it's still out there 🙂 But the requirement is even more complicated,...

Yes, that's OK.

I forgot to mention, that because I was using my own made up data, I can be sure that it is correct, so you should definitely check it for validity...

sperry (5/18/2009)

---

Hi RBarryYoung.

Thanks so much for your hard work. I ran the script (the one that uses tmp tables) this morning and results were returned in just over 20mins. ...

Goto my earlier post (above) and hit the "QUOTE" button. This allows you to reply to a post, and also includes the whole thing quoted, as I originally wrote...

You need to put XMl in code tags to be visible here, like this:

123

test

first

1000

second

2000

234

abc

first

100

second

200

I hear that. 🙂

Let us know what you find out.

Thanks, sperry, be sure to let us know how it works out.

Are you using VB.net? The Image datatype requires specialized handling, especially from client code. I think that you would be better to use Varbinary(MAX), passed through a parametized...

Here is the best result that I could get with a single query:

--create proc spSurnameMatching_CTEAnswer AS

--====== Find all Person-subsets that 95% match persons

;WITH cteSurname95 as (

Select Source_name, Name_Variation

...

OK, I made my own table definitions and generated random data to make a more real performance test. After that, it became apparent that the problem was coming from...

Here's how Florian's answer would be implemented with this more relational table design:

SELECT

m.*,

REPLACE(m.Message, '@var@', e.ErrorMsg)

FROM...

anila_jkhwaja (5/16/2009)

---

Thanks Flo for the prompt response

but its not what i actually want

you have restricted the Columns in Case Statement, i want it to be a dynamic one

like if in...

Although this example is also not dynamic.