Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,716 through 14,730 (of 59,097 total)

RE: How to SELECT * INTO [temp table] FROM [Stored Procedure]?

Also, sp_who2 returns 2 columns named "SPID" and that will cause an error during the SELECT INTO.
--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 21, 2017 at 7:44 am

#1952086
RE: Installing SSIS alongside Current SQL Instance

The real question is, why do you think you need SSIS? What will you actually be using it for? It may be that you don't actually need SSIS to do...
--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 21, 2017 at 5:39 am

#1952042
RE: Time difference

I'll also ask the question of, is there any guarantee that for every "I", there will be a related "O" and vice versa?
--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 21, 2017 at 5:35 am

#1952041
RE: Concatenate rows into string

Alan.B - Thursday, July 20, 2017 7:30 AM
DesNorton - Thursday, July 20, 2017 5:29 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 21, 2017 at 5:28 am

#1952040
RE: Are the posted questions getting worse?

Brandie Tarvin - Friday, July 21, 2017 4:23 AM
Two things...
1) Y'all are WEIRD.
2) Thank goodness that y'all are weird. It makes me...
--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 21, 2017 at 5:21 am

#1952035
RE: SSMS is Free

I hate the fact that neither SSMS or Books Online comes with SQL Server anymore.
--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 20, 2017 at 8:15 pm

#1951994
RE: Microsoft SQL Server Utilities and Tools

robert.sterbal 56890 - Thursday, July 20, 2017 7:54 AM
I've decided to try to put up a wiki on Github. I may move...
--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 20, 2017 at 12:16 pm

#1951941
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, July 20, 2017 9:34 AM
Jason A. Long - Thursday,...
--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 20, 2017 at 12:09 pm

#1951937
RE: Are the posted questions getting worse?

Brandie Tarvin - Wednesday, July 19, 2017 12:32 PM
Ed Wagner - Wednesday, July 19, 2017 10:43 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 20, 2017 at 8:55 am

#1951867
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, July 19, 2017 1:51 PM
Lynn Pettis - Wednesday, July 19, 2017 1:33 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 20, 2017 at 8:42 am

#1951864
RE: Are the posted questions getting worse?

Lynn Pettis - Wednesday, July 19, 2017 1:33 PM
Jeff Moden - Wednesday, July 19, 2017 1:27 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 20, 2017 at 8:39 am

#1951862
RE: Are the posted questions getting worse?

TomThomson - Wednesday, July 19, 2017 3:13 PM
Phil Parkin - Wednesday, July 19, 2017 8:49 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 20, 2017 at 8:36 am

#1951860
RE: Are the posted questions getting worse?

Grant Fritchey - Thursday, July 20, 2017 7:56 AM
Jeff Moden - Thursday, July 20, 2017 7:50 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 20, 2017 at 7:59 am

#1951847
RE: Are the posted questions getting worse?

Ed Wagner - Wednesday, July 19, 2017 1:53 PM
Jeff Moden - Wednesday, July 19, 2017 1:24 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 20, 2017 at 7:50 am

#1951839
RE: Are the posted questions getting worse?

TomThomson - Wednesday, July 19, 2017 3:21 PM
WayneS - Wednesday, July 19, 2017 12:10 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 20, 2017 at 7:42 am

#1951836

Viewing 15 posts - 14,716 through 14,730 (of 59,097 total)