o.kaesmann (2/2/2016)

---

I do use it in production environmentbecause of getting date from other Systems that conteins duplicatetd data (don't ask ....) and it works fine.

In the past i've worked on...

True, I was only thinking of duplicates. This fixes that though:

delete Customers

where CustName in (

...

It only picks the min or max CustID for the pair of duplicates.

Wouldn't this be a simpler solution and be a bit less confusing?

delete Customers

where CustID in (

...

I found that I had to remove the literal quotename function call from the first select:

[font="Courier New"] select ''' + ''' + quotename(column_name) + ' = ''...

I've done this loads of time using TSQL sps and dynamic sql within, much in the same way as the CLR routine. Is there an advantage to using CLR over...

Excellent solution. I would have written a loop:

while (charindex(' ', @myString) > 0) begin

set @myString = replace( @myString, ' ', ' ');

end;

but your solution...

Consider using code that catches the error and raises the error to the calling program:

proc1:

begin try

exec proc2;

end try

begin catch

declare

...

Thanks Lowell. This solution works somewhat. I see that the results get truncated, whereas in the grid view, they are not. Is there a setting that controls how much of...