I'll admit that I often prefer to transform data inside of a SQL Server target, OLTP or DW database. The reason is that mass changes are often easier with...

What did the DBA say to the Developer?
It doesn't matter, he wasn't listening anyway

I don't know what the issue is here but you could use ngrams8k to perform an character by character analysis like this: 

-- sample data
DECLARE @table table(someId int...

@Jeffrey Williams 3188
Ditto what Lynn said about...

My apologies if I came off as rude. I was just trying to point out that what you posted was overkill for the requirement. I write must faster code than...

Can you post some DDL for the tables that you are pulling data from (Note the link in my signature line for best practices on getting help)

The job title of DBA means different things to different people. Luis touched on some of the core responsibilities. My first question would be: what is their job description -...

Some code formatting food for thought...
For cases where I need to repeat the same expression multiple times you can create on "on-the-fly" inline function to simplify your code. In...