Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,986 through 12,000 (of 59,095 total)

RE: Sort column without ORDER BY

DesNorton - Wednesday, June 27, 2018 11:52 PM
If you add a ROW_NUMBER() it will return in the sort order of the ROW_NUMBER.
Technically,...
--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)

June 28, 2018 at 12:08 am

#1995556
RE: Sort column without ORDER BY

ravikanth_b - Wednesday, June 27, 2018 10:26 PM
I was patiently trying to work with her with possible solution but you have to...
--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)

June 27, 2018 at 11:20 pm

#1995550
RE: Sort column without ORDER BY

Yes. It can actually be done rather reliably but MS will never support it. You need to do several things...
1. The table must have a Clustered Index that is...
--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)

June 27, 2018 at 11:13 pm

#1995549
RE: Automating activity logging

EMtwo - Wednesday, June 27, 2018 1:20 PM
Lynn Pettis - Wednesday, June 27, 2018 11:00 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)

June 27, 2018 at 10:39 pm

#1995546
RE: URGENT NEED :: Senior SQL Server Developer in Boston, MA area.

Ah... Ok. Understood. Thanks for the feedback.
--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)

June 27, 2018 at 10:21 am

#1995484
RE: Automating activity logging

EMtwo - Wednesday, June 27, 2018 9:27 AM
Thank you. Your help is appreciated. I'd like to load the result from this...
--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)

June 27, 2018 at 10:04 am

#1995479
RE: URGENT NEED :: Senior SQL Server Developer in Boston, MA area.

vishaldiaspark22 - Wednesday, June 27, 2018 8:33 AM
We are looking for a Senior SQL Server Developer
Type of hire: Contract to...
--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)

June 27, 2018 at 9:56 am

#1995478
RE: When it comes to salaries, I'm not average

Eric M Russell - Wednesday, June 27, 2018 8:45 AM
If you're interviewing to fill an experienced T-SQL developer position, and only 1...
--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)

June 27, 2018 at 9:33 am

#1995471
RE: TempDB

msimone - Wednesday, June 27, 2018 8:25 AM
Jeff, thank you very much.
You're welcome. Thank you for the feedback.
Sue is also correct in...
--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)

June 27, 2018 at 9:18 am

#1995467
RE: When it comes to salaries, I'm not average

jasona.work - Wednesday, June 27, 2018 6:33 AM
xsevensinzx if you prefer, perhaps a different analogy might be asking someone who's applied for...
--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)

June 27, 2018 at 8:39 am

#1995460
RE: When it comes to salaries, I'm not average

xsevensinzx - Tuesday, June 26, 2018 3:28 PM
First of all, you cannot compare a hammer to a carpenter to getting 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)

June 26, 2018 at 7:33 pm

#1995402
RE: Are the posted questions getting worse?

I've never been to Columbus, OH before. Any recommendations for a hotel near the SQL Saturday there?
Never mind. I've booked the Hilton Polaris for Friday and Saturday...
--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)

June 26, 2018 at 7:18 pm

#1995401
RE: When it comes to salaries, I'm not average

ZZartin - Tuesday, June 26, 2018 3:56 PM
xsevensinzx - Tuesday, June 26, 2018 3:28 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)

June 26, 2018 at 7:02 pm

#1995400
RE: Are the posted questions getting worse?

Michael L John - Tuesday, June 26, 2018 6:12 PM
jasona.work - Tuesday, June 26, 2018 12:47 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)

June 26, 2018 at 6:58 pm

#1995399
RE: When it comes to salaries, I'm not average

By the same token, if someone claims that they have "10 years of experience developing stored procedures, functions, and triggers in SQL Server" and they can't answer the super simple...
--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)

June 26, 2018 at 2:06 pm

#1995370

Viewing 15 posts - 11,986 through 12,000 (of 59,095 total)