Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,851 through 11,865 (of 59,095 total)

RE: Repeat union all according to an input parameter

jcelko212 32090 - Sunday, July 15, 2018 4:36 PM
First of all, we never like to use SELECT * in production code....
--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)

July 15, 2018 at 7:51 pm

#1997625
RE: Finding a particular date in all tables

JaybeeSQL - Sunday, July 15, 2018 12:37 AM
HI all,
The famous SearchAllTables proc failed to find date values I know exist in my...
--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)

July 15, 2018 at 7:44 pm

#1997624
RE: Need Help to convert DATETIME result into DATE on SQL Server

jcelko212 32090 - Sunday, July 15, 2018 4:41 PM
Nexana - Monday, July 9, 2018 8:37 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)

July 15, 2018 at 7:16 pm

#1997623
RE: Who Likes NULL?

Dennis Q Miller - Sunday, July 15, 2018 9:10 AM
Consider this EMPLOYEE, non-example which attempts to represent an unknown date 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)

July 15, 2018 at 7:07 pm

#1997622
RE: Who Likes NULL?

Dennis Q Miller - Sunday, July 15, 2018 10:18 AM
I don't see much difference between using 1/1/9999 to represent "unknown" 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)

July 15, 2018 at 7:06 pm

#1997621
RE: The Age of Multiple Databases

What I frequently find is that a lot of people use the latest new shiny object just to become a member of the too-cool-for-school crowd. I also find that even...
--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)

July 15, 2018 at 8:46 am

#1997611
RE: SQL Query Structure Training

It's certainly not a panacea but there is a thought process that helped me immensely. So much so that I added to my signature line below years ago. That 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)

July 15, 2018 at 8:24 am

#1997610
RE: Problem with Sqlservr.exe -m

Miron Berlin - Sunday, July 15, 2018 2:55 AM
Carl Federl - Monday, May 26, 2008 8:50 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)

July 15, 2018 at 8:01 am

#1997609
RE: Need Help to convert DATETIME result into DATE on SQL Server

Nexana - Saturday, July 14, 2018 5:12 PM
Jeff Moden - Friday, July 13, 2018 10: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)

July 15, 2018 at 7:47 am

#1997608
RE: Are the posted questions getting worse?

JaybeeSQL - Sunday, July 15, 2018 6:08 AM
Jeff Moden - Thursday, July 12, 2018 8:52 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)

July 15, 2018 at 7:40 am

#1997607
RE: Need Help to convert DATETIME result into DATE on SQL Server

Eirikur Eiriksson - Saturday, July 14, 2018 12:34 PM
Jeff, where should I start on this? Not translating the binary values, in the...
--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)

July 15, 2018 at 7:27 am

#1997606
RE: how do i find a specific status, and only that status

Lynn Pettis - Tuesday, July 10, 2018 12:40 PM
So am I wrong to provide other alternatives? Is so I will just go...
--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)

July 14, 2018 at 10:30 am

#1997594
RE: how do i find a specific status, and only that status

Lynn Pettis - Tuesday, July 10, 2018 9:36 AM
John Mitchell-245523 - Tuesday, July 10, 2018 9:26...
--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)

July 14, 2018 at 10:21 am

#1997593
RE: how do i find a specific status, and only that status

saravanatn - Saturday, July 14, 2018 12:57 AM
Jeff Moden - Friday, July 13, 2018 9:37 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)

July 14, 2018 at 9:22 am

#1997592
RE: Importing XML Files into a flat table

Luke L - Saturday, July 14, 2018 8:17 AM
Jeff Moden - Saturday, July 14, 2018 7:16 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)

July 14, 2018 at 9:13 am

#1997591

Viewing 15 posts - 11,851 through 11,865 (of 59,095 total)