Thanks Jeff - I fixed my code. I was using my own DB and forgot to remove the...

UPDATED 10/31/2024

The was an error in my code, I just changed  "bernieML.samd.ngrams8K" to "dbo.ngrams8K". I was using code from my own DB (BernieML) with a different schema (samd).

• This reply was modified 3 weeks, 5 days ago by  Alan Burstein.

There's always MS Data Quality Services (DQS). It allows for data cleansing, matching, de-duplication and an array of related data quality services. It's not easy to use but does...

For this you can use a "splitter" (AKA "tokenizer" function.)

DECLARE @String VARCHAR(8000) = 'Hello world. #1234 has been replaced by #014521';

SELECT SomeNbr = REPLACE(split.[value],'#','')
FROM STRING_SPLIT(@String,' ') AS...

Post got submitted twice. Sorry.

• This reply was modified 1 month ago by  Alan Burstein. Reason: Dupe

Another problem I’ve seen frequently is the overuse of user-defined functions (UDFs), especially nesting scalar UDFs.

scalar UDFs, nested or not, tend to burn the house down.  When used in a...

Glen - I love this article. Amazing stuff. I read some of it and skimmed the rest but can't wait until I have time to play with your code a...

Thanks for the replies and sorry for being a Ghost OP.

To me, the above makes sense based on the wording of those metrics and is useful information.  Does the above...

Adi did it like I would. His excellent solution could be simplified as

SELECT t.FamilyID, t.PortionKey, t.GroupID, GeneratorNumber = 
        ...

I would write it using EXISTS instead of INs. It's easier if you use table aliases.

I always use EXISTS instead of IN. Best case - it performs better, worse case...

Note that the "./" in your code is not required based on the XML Context. Also note that specifying that you need the elements' text, via text(), will improve performance.

For...

To better understand the problem and solution have a look at Well Formed XML:

This is my first time messing with JSON in SQL. The BOL entry on this helped me.

First, JSON is cases sensitive so, $.Data is not the same as $.data. Next,...

As Jeff mentioned, CONVERT + 101 gets you the formatting you need:

SELECT CONVERT(VARCHAR(10), GETDATE(), 101);

For the last day of the previous month:

SELECT EOMONTH(DATEADD(MONTH,-1,GETDATE()));

For the...

You can create your own INSTR function leveraging ngrams8k.

CREATE OR ALTER FUNCTION dbo.Instr8K
(
  @string   VARCHAR(8000),
  @search   VARCHAR(100),
  @instance INT
)
/*
Created by...