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 2 weeks 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 2 weeks, 3 days ago by naumon765.

• This reply was modified 2 weeks, 3 days 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 2 weeks, 5 days 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 ago by naumon765.
• This reply was modified 1 months 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 ago by naumon765.
• This reply was modified 1 months ago by naumon765.
• This reply was modified 1 months ago by naumon765.
• This reply was modified 1 months 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 ago by naumon765.

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