Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,391 through 12,405 (of 59,099 total)

RE: Without using group_by or xml_path how to concatenate multiple rows of a same id into a single row

manibad - Wednesday, May 9, 2018 4:12 AM
Input:
ID             DESCRIPTION
1            An
1            Apple
1            a
1            day
1            keeps
1            doctor
1            away
2            hello
3            The
3
3            XYZ
3            XYZZ
OUTPUT
ID             DESCRIPTION
1            An,Apple,a,day,keeps,doctor,away
2            hello
3            The,,XYZ,XYZZ
Have implemented using xml_path with stuff.
But I will be having millions of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 9, 2018 at 2:17 pm

#1989950
RE: Removing stored procedures to move to cloud

Steve Jones - SSC Editor - Tuesday, May 8, 2018 8:47 AM
Also, what you're describing is what DevOps is about.
Agreed. And...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 8, 2018 at 5:09 pm

#1989806
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Tuesday, May 8, 2018 3:45 PM
sgmunson - Tuesday, May 8, 2018 3:00 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 8, 2018 at 4:11 pm

#1989799
RE: Removing stored procedures to move to cloud

Orlando Colamatteo - Tuesday, May 8, 2018 12:55 AM
Jeff Moden - Monday, May 7, 2018 11:18 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 8, 2018 at 8:15 am

#1989682
RE: Removing stored procedures to move to cloud

Steve Jones - SSC Editor - Monday, May 7, 2018 9:25 AM
Jeff Moden - Monday, May 7,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2018 at 11:18 am

#1989547
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Monday, May 7, 2018 8:16 AM
ScottPletcher - Monday, May 7, 2018 7:58 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2018 at 8:53 am

#1989520
RE: Removing stored procedures to move to cloud

sgmunson - Monday, May 7, 2018 6:56 AM
Orlando Colamatteo - Saturday, May 5, 2018 6:44 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2018 at 7:34 am

#1989498
RE: The SQL Joke Thread

TitusCrews - Monday, May 7, 2018 6:55 AM
A guy was smoking and puffing smoke rings in the air..
His girlfriend gets irritated with...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2018 at 6:59 am

#1989494
RE: our Brother Technical Support Number +1-833-445-7444 USA

techprinter3 - Monday, May 7, 2018 4:53 AM
If youâ€™re printer just died or completely stopped working, no need to worry. You can...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 7, 2018 at 6:56 am

#1989492
RE: Number of Days between two Day Names

David Burrows - Sunday, May 6, 2018 3:11 AM
Wow this thread went a bit sideways 🙁
It was a fun post. Patrick...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2018 at 9:12 pm

#1989453
RE: The Technology Journey to Disaster

Sergiy - Sunday, May 6, 2018 7:09 AM
Jeff Moden - Sunday, May 6, 2018 12:22 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2018 at 9:07 pm

#1989452
RE: The Technology Journey to Disaster

I had a boss that said "If you never make a mistake, then I'm not pushing you hard enough".
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2018 at 12:22 am

#1989418
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Saturday, May 5, 2018 5:19 PM
Jeff Moden - Saturday, May 5, 2018 5:00 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 6, 2018 at 12:01 am

#1989417
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Saturday, May 5, 2018 4:44 PM
Jeff Moden - Saturday, May 5, 2018 4:21 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 5, 2018 at 5:00 pm

#1989409
RE: Number of Days between two Day Names

patrickmcginnis59 10839 - Saturday, May 5, 2018 3:45 PM
Jeff Moden - Saturday, May 5, 2018 3:32 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 5, 2018 at 4:21 pm

#1989407

Viewing 15 posts - 12,391 through 12,405 (of 59,099 total)