Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,066 through 13,080 (of 59,099 total)

RE: Question Regarding Date logic

jcelko212 32090 - Tuesday, January 23, 2018 10:59 AM
Jeff Moden - Tuesday, January 23, 2018 9:47 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)

January 23, 2018 at 11:49 am

#1976969
RE: Question Regarding Date logic

jcelko212 32090 - Tuesday, January 23, 2018 8:30 AM
Please read any book on modern programming and pay attention to the concept of...
--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)

January 23, 2018 at 9:47 am

#1976942
RE: Question Regarding Date logic

below86 - Tuesday, January 23, 2018 7:44 AM
Jeff Moden - Monday, January 22, 2018 7:07 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)

January 23, 2018 at 9:37 am

#1976936
RE: Changing Extensions

@steve-2 Jones,
Whether or not I agree with the use of answer 4 and whether or not it has a shedload of caveats associated with it and whether or...
--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)

January 23, 2018 at 6:45 am

#1976889
RE: Changing Extensions

manik_anu - Tuesday, January 23, 2018 12:28 AM
ildjarn.is.dead - Monday, January 22, 2018 6: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)

January 23, 2018 at 6:38 am

#1976888
RE: Question Regarding Date logic

drew.allen - Monday, January 22, 2018 2:27 PM
Note that it is NOT the beginning of the week.
"It Depends". Day 0 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)

January 22, 2018 at 7:19 pm

#1976850
RE: Question Regarding Date logic

below86 - Monday, January 22, 2018 12:49 PM
I would say using 0 to represent 01-01-1900 or -1 to mean 12-31-1899 is far...
--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)

January 22, 2018 at 7:07 pm

#1976849
RE: Changing Extensions

Bobby Russell - Monday, January 22, 2018 11:11 AM
Jeff Moden - Monday, January 22, 2018 10:59 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)

January 22, 2018 at 6:10 pm

#1976845
RE: Question Regarding Date logic

below86 - Monday, January 22, 2018 10:58 AM
In a follow up post KGJ-dev wanted to be able to pass any number of...
--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)

January 22, 2018 at 11:04 am

#1976769
RE: Changing Extensions

Bobby Russell - Monday, January 22, 2018 10:16 AM
Item 4 was my choice, which IS correct whether you think so or not, 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)

January 22, 2018 at 10:59 am

#1976766
RE: Need to convert lowercase characters to 'a' and uppercase to 'A'

srikanthrv - Monday, January 22, 2018 8:38 AM
ThomasRushton - Monday, January 22, 2018 8: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)

January 22, 2018 at 9:07 am

#1976747
RE: Changing Extensions

George Vobr - Monday, January 22, 2018 7:59 AM
ildjarn.is.dead - Monday, January 22, 2018 6: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)

January 22, 2018 at 8:15 am

#1976730
RE: Need to convert lowercase characters to 'a' and uppercase to 'A'

drew.allen - Monday, January 22, 2018 7:38 AM
Jeff Moden - Friday, January 19, 2018 9:59 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)

January 22, 2018 at 8:12 am

#1976729
RE: Changing Extensions

ildjarn.is.dead - Monday, January 22, 2018 6:48 AM
Jeff Moden - Monday, January 22, 2018 5:44 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)

January 22, 2018 at 7:00 am

#1976715
RE: Ways to determine what increased the log file.

adilahmed1989 - Monday, January 22, 2018 2:37 AM
John Mitchell-245523 - Monday, January 22, 2018 2: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)

January 22, 2018 at 6:35 am

#1976710

Viewing 15 posts - 13,066 through 13,080 (of 59,099 total)