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

• This reply was modified 2 weeks, 3 days ago by naumon765.
• This reply was modified 2 weeks, 3 days ago by naumon765.
• This reply was modified 2 weeks, 3 days ago by naumon765.
• This reply was modified 2 weeks, 3 days ago by naumon765.

then the ""MAIN""" question is

PRACTICAL implementation  ( how ??? )

not exists "preferred"  "better in all sorts " over left join

“Everything I Needed to Know Used to Be Found in One Book”

I’ve worked in the software industry since 1998.

Back then, learning was different.

If you had one solid book, enough curiosity,...

hi

my query = worst

Paul White / Steve Query  = Best