Just to be sure, it wasn't meant as any kind of slam for missing something, Phil. ...

Following on from Jeff's excellent advice, I'd like to add a little more. I'd suggest removing all spaces from your column names ... makes your code much less cumbersome...

As a matter of safety in the future, you should always include the schema name in the object name.

Also, you should get into the habit of using properly placed semi-colons...

The datatype for the Created column wasn't expressed in the test data that you nicely provided.  I'm presuming that it's not actually a VARCHAR datatype in the following test data...

BWAAAAA-HAAAAA-HAAAAA!!! HOOOOOOIIIIIIEEEEE!!!!

I was in the process of submitting an article through the "Write for us" link and I saw the following at the top.

Which of...

That sounds...

Ahh, yes the table does have a full text definition.  It's just not finding   A00J010002158.  If I do like '%A00J010002158', it finds it.  But that is very slow.  ...

Although I suspect it will actually be fairly rapid, there's no way to guesstimate such a thing.  Create a smaller test of a couple million rows and measure.  You should...

Ok... both of you need to read'n'heed the article at the link in my signature line below if you want help.  Posting data as text doesn't help or are answering...

This is why I tell people to NOT rely on "OPS" (Other People's S**T)!  Teach yourself how to do it using their code as an example and write your own...

p.s.  If you'd like to learn more about the very useful method of conditionally grouping dates by simple subtraction of an increasing number, please see the following article.

https://www.sqlservercentral.com/articles/group-islands-of-contiguous-dates-sql-spackle

Hi Likiraght and welcome aboard!

Your question is good and so is your test data but you'll find that almost everyone likes to test their coded solutions before they post a...

When are you getting this error?  When you try to use xp_CmdShell?  If so, please post the code.

Hmmm... then the only reason I can...