Jeff Moden

Forum Replies Created

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

RE: Adding a Qualifier inside a format file .xml

Does column 5 make consistent use of being wrapped in double quotes?
--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:47 pm

#1995716
RE: Are the posted questions getting worse?

I've spit out a whole lot of craft beers and imports. Although I'll freely admit to an unsophisticated palette, I've never spit out a Bud or PBR. As for warm...
--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:35 pm

#1995715
RE: Sort column without ORDER BY

ravikanth_b - Thursday, June 28, 2018 11:48 AM
I spent more than 15 years working on Oracle/SQL Server/MySQL and Big Data/NoSQL in architecture...
--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:27 pm

#1995714
RE: Sort column without ORDER BY

ravikanth_b - Thursday, June 28, 2018 12:16 AM
I told the all the possible answers, she dint like it. I even asked what...
--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 8:54 am

#1995644
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

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