This isn't the right way to do things.  You can easily get to the point of where your system is doing nothing but rollbacks.  You could also be causing grave...

Exactly.  I summarize that as being "Confidently Incorrect" and, in that area, ChatGPT...

@jonathan-2,

While the AI is quite capable of explaining exactly WHAT the code does programmatically, it's simply not capable of figuring out the WHY for most code.  For example, the AI...

From what I have seen the people I would regard as being at the top of their profession have certain traits.

• Competence with confidence
• Natural teachers.  If feels like...

Not aimed at the author but aimed at the whole concept...  Let's look at the first example prompt in the article...

You are an SQL Server database developer. Assume you...

Heh... let's look at the first paragraph in the article...

It's a good idea to learn more about different technologies. I've been amazed throughout my career, and even now as...

Not enough info... we're just guessing from descriptions.  Please see the article at the 2nd link in my signature line below for what to post for these types of performance...

Possible solution to the original question...

Given the original example data...

Create Table #Payments (ID int, Comment Text)

INSERT INTO #payments values (1, '65607 Processed via? DISC Last 4 digits...

In this case I would start splitting the comment based on a space.

check "Tally OH! An Improved SQL 8K “CSV Splitter” Function"

and process the spliter results...

• This reply was modified 2 years ago by Jeff Moden.

Phil Parkin will tell you that I'm not a big fan of SSIS or most of the any other 4 letter words in SQL Server.

That not withstanding and with the...

Rule number 1: Claims of efficiency and/or performance MUST be accompanied by demonstrable code to prove it.

Third, the clustered index does store data in physical order on pages. The pagse/extents could get out of order, which is fragmentation, but that doesn't change the physical nature...

And I dont think its going to be fast with that many records - was really just hoping that there might be a faster way that I wasn't thinking...

Jeff

the query is the slow part of a larger process.its not being posted to a screen - query is part of universe of claims process that needs to look...

Hi Steve,

Thanks for getting back. I was given this table and figured out that this field a varchar(4000) was the field with the start and end dates times.  I...