Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,251 through 14,265 (of 59,097 total)

RE: Get the year and Qtr

Jason A. Long - Monday, September 25, 2017 10:42 AM
I've gotta go w/ Scott of this one... At some point, you...
--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)

September 25, 2017 at 11:42 am

#1960818
RE: Get the year and Qtr

ScottPletcher - Monday, September 25, 2017 9:53 AM
I suppose it's a matter of philosophy too. In my view, queries should not check...
--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)

September 25, 2017 at 11:38 am

#1960817
RE: Get the year and Qtr

ScottPletcher - Monday, September 25, 2017 8:14 AM
Jeff Moden - Saturday, September 23, 2017 8: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)

September 25, 2017 at 9:40 am

#1960783
RE: Get the year and Qtr

Ah... almost forgot. Neither Scott's nor mine checks to make sure the values of YYYY and MM are actually part of a valid date. Ostensibly, that's already been checked but...
--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)

September 23, 2017 at 8:24 pm

#1960630
RE: Get the year and Qtr

When I looked at the posted solutions, I was pretty sure that Scott's would be the fastest because of both not using CROSS APPLY and the Integer math he used. ...
--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)

September 23, 2017 at 8:07 pm

#1960629
RE: File with Datetime

Thom A - Friday, September 22, 2017 7:53 AM
This appears to be a duplicate of https://www.sqlservercentral.com/Forums/FindPost1898512.aspx
Agreed.... no posts here, please. ...
--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)

September 23, 2017 at 11:48 am

#1960621
RE: Substring

Thom A - Friday, September 22, 2017 7:59 AM
hoseam - Friday, September 22, 2017 7: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)

September 23, 2017 at 11:47 am

#1960620
RE: Setup the sync process against Large Database

Amit Kumar-481560 - Friday, September 22, 2017 11:31 AM
Jeff Moden - Wednesday, September 20, 2017 10:28 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)

September 22, 2017 at 11:40 pm

#1960612
RE: Get the year and Qtr

Luis Cazares - Friday, September 22, 2017 10:15 AM
Papil - Friday, September 22, 2017 9:48 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)

September 22, 2017 at 9:26 pm

#1960610
RE: Help from Cortana

I think the irony of it all is funny as hell. We can't get folks to make decent GUIs and yet we're going to trust a bot and voice recognition? ...
--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)

September 22, 2017 at 8:34 pm

#1960609
RE: Are the posted questions getting worse?

Michael L John - Friday, September 22, 2017 9:54 AM
Jeff Moden - Thursday, September 21, 2017 11:42...
--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)

September 22, 2017 at 7:24 pm

#1960606
RE: Are the posted questions getting worse?

crow1969 - Thursday, September 21, 2017 9:34 AM
I would guess the conversion routine simply drops all thousands separators, and then converts 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)

September 21, 2017 at 11:42 pm

#1960435
RE: Mortgage amortization table

Jason A. Long - Wednesday, September 20, 2017 9:43 PM
You don't pay interest on interest ever. Unpaid interest and principal balance are...
--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)

September 21, 2017 at 7:10 am

#1960357
RE: General interview questions

Check out the following...
https://www.youtube.com/watch?v=XKu_SEDAykw
I'm not a C# programmer but my personal feeling is that both the interviewer and the interviewee failed massively. For example, both talked about...
--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)

September 20, 2017 at 10:27 pm

#1960305
RE: Challenge: Insert a specific number of rows based on an integer column in one query!

Jasmine D. Adamson - Wednesday, September 20, 2017 6:03 PM
Thanks Jeff, those are very helpful! I like that way of describing what's...
--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)

September 20, 2017 at 8:43 pm

#1960301

Viewing 15 posts - 14,251 through 14,265 (of 59,097 total)