Depending on how your data is set up, this might work for you too.

DECLARE @Chars2Remove VARCHAR(20) = 'ACDIPFJZ';

WITH RowsToCheck AS

(

SELECT s

FROM

...

John Hick-456673 (12/16/2014)

---

I like the concept, but I don't like extraneous function calls:

"WHERE a.Last_Status_DT >= DATEADD(day, -@LookbackDays, @CurrentDT)"

My preference would be to place the DATEADD clause in yet another variable...

fregatepallada (12/15/2014)

---

Manie, we all had our "CLIENT IS ALWAYS RIGHT" moments, even when client was 100% absolutely wrong.

How about user request to implement 5 different data interfaces for 5...

Actually I have the utmost respect for them. After all,...

I never said I was above my users. Heck, most of them get paid more than me anyway!

fregatepllada (12/15/2014)

---

In advanced search situation instead of creating acrobatic code on back end I just added a simple validation on front end that at least one input parameter has to...

g.britton (11/6/2014)

---

Just thought I add my minimalist CTE-based tally table generator:

declare @howmany int = 50;

with n1(n) as (select 1 from (values (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) n(n)),

...

DonlSimpson (10/2/2014)

---

Maybe I'm missing something here, but this is simple and fast:

declare @t varchar(5000) = 'RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row." This-divided-by,that|&/multiplied\by(100)give*you,%;<percent>.'

declare @s-2 varchar(5000)...

Jeff,

You are correct. Adding that TYPE/value to the FOR XML is going to kill the performance of the string cleaner I posted. Which of course, I mistakenly tried...

Interesting. I wouldn't have thought that would be possible.

Excellent article Gail and I rated it accordingly!

I particularly like you analogy to sunk costs. Surprising how few people understand that basic economic principle.

For this problem I personally have not. The solution is designed for folks that can't use CLR on their servers.

Thanks for taking a...

Bwhahahahahahaha! Just imagine how much you'd make renting out your frozen pork chop launcher if they did!

Jeff Moden (9/5/2014)

---

That took me by surprise the first time I worked with Oracle, as well. NULL same as '' not same as ' '.

The other thing that took...

Like, so by many, you mean more than 9?