thats SORT OF  "sorta"

one way of seeing things ( sh..t loads of different types of  thinkings  are there )

made using AI

see THERE are many things people do ???

if government wants humans to do it or "in the loop"

follow exactly what they say becuase thats what they want

but HOW HOW do...

• This reply was modified 1 weeks, 5 days ago by naumon765.

why 3 columns with 3 numbers to make sense ...just 1 number

search replace script with powerful regex ( example python ) is the best so far

... unless usng AI

• This reply was modified 1 weeks, 5 days ago by naumon765.
• This reply was modified 1 weeks, 5 days ago by naumon765.
• This reply was modified 1 weeks, 5 days ago by naumon765.
• This reply was modified 1 weeks, 5 days ago by naumon765.

hi Jeff    Here it is

-- 1. LEAD/LAG (Window Function)
SELECT
StartGap = id,
EndGap = LEAD(id) OVER (ORDER BY id),
FirstAvailable = id + 1,
LastAvailable = LEAD(id) OVER (ORDER BY...

• This reply was modified 1 months ago by naumon765.

2 things

1. as a software(coding)  LOVER ..   other things could have been discussed and  noticed
2. string pattern .. powerful regex ..  PYTHON is A MUCH BETTER choice than t-sql  .....

hi hope this helps    please excuse .. T-SQL

since STRING Pattern  ... PYTHON RegEx very powerful

in powershell .. using 3Dimensional Araay  ... please excuse T-sql forum

Result   3 ,  6      .. Voila ...  🙂

• This reply was modified 1 months, 1 weeks ago by naumon765.

• This reply was modified 1 months, 1 weeks ago by naumon765.

How To Format Phone Number

Python = Powerful Regular Expressions        very short code = easy to implement

hi hope this helps

know this is sql server t-sql question  .. please excuse

python .... just a single "short" regex  .. simply amazing

# Find all matches inside [##...##]

matches = re.findall(r'\[##(.*?)##\]', text)

• This reply was modified 1 months, 1 weeks ago by naumon765.

hi Steve

point A to point B

"quickest" "least resource intensive .. in .. [ human efforts ] " "output accurate and consistent"

how you do it ?? your choice LLM BLM or...

• This reply was modified 1 months, 3 weeks ago by naumon765.
• This reply was modified 1 months, 3 weeks ago by naumon765.

hi Jonathan

powershell   python  used ( very easy and simple = powerful regex both python powershell )

powershell   ... data store , get  max per group of animals , return "max per...

• This reply was modified 1 months, 3 weeks ago by naumon765.
• This reply was modified 1 months, 3 weeks ago by naumon765.
• This reply was modified 1 months, 3 weeks ago by naumon765.
• This reply was modified 1 months, 3 weeks ago by naumon765.

SQL SERVER  2008 = compatible 

/*===========================================
    SECTION 1: Create PATTERNS table
===========================================*/
IF OBJECT_ID('PATTERNS') IS NOT NULL DROP TABLE PATTERNS;

CREATE TABLE PATTERNS (
  ...

Hi Jeff,

Thanks for taking the time to share your thoughts. I wanted to mention that I do not like  the formatting of  sqlservercental.com code

While I understand it can be useful,...

• This reply was modified 1 months, 3 weeks ago by naumon765.