Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,041 through 23,055 (of 59,067 total)

RE: How to Handle Calculations Related to fiscal year and quarter

Jeff Moden (7/28/2014)
bpatin (7/28/2014)
This got me a few times in queries where I've used BETWEEN @FromDate AND @ToDate in the WHERE clause, and the data type may be either smalldatetime...
--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 28, 2014 at 6:18 pm

#1733067
RE: How to Handle Calculations Related to fiscal year and quarter

bpatin (7/28/2014)
This got me a few times in queries where I've used BETWEEN @FromDate AND @ToDate in the WHERE clause, and the data type may be either smalldatetime or datetime....
--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 28, 2014 at 5:22 pm

#1733061
RE: How to Handle Calculations Related to fiscal year and quarter

gbritton1 (7/28/2014)
Jeff Moden (7/28/2014)
gbritton1 (7/28/2014)
Jeff Moden (7/28/2014)
g.britton (7/27/2014)
Much better to use a date dimension table that contains all relevant date info for your company. You can include columns like...
--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 28, 2014 at 5:13 pm

#1733058
RE: Frustration with Bad Design

Steve Jones - SSC Editor (7/28/2014)
Jeff Moden (7/28/2014)
djackson 22568 (7/28/2014)
David.Poole (7/28/2014)
And where does Edward Snowden fit into this piece?
IMO Snowden is a hero. He broke the law in order...
--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 28, 2014 at 5:03 pm

#1733057
RE: Frustration with Bad Design

djackson 22568 (7/28/2014)
David.Poole (7/28/2014)
And where does Edward Snowden fit into this piece?
IMO Snowden is a hero. He broke the law in order to expose our government's illegal violation 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)

July 28, 2014 at 3:05 pm

#1733019
RE: Are the posted questions getting worse?

Just to be clear, I have no hatred for Stack Overflow. It provides a huge service to the community. This whole thing started about the "BS around rep"...
--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 28, 2014 at 8:00 am

#1732864
RE: How to Handle Calculations Related to fiscal year and quarter

gbritton1 (7/28/2014)
Jeff Moden (7/28/2014)
g.britton (7/27/2014)
Much better to use a date dimension table that contains all relevant date info for your company. You can include columns like 'IsHoliday' or 'IsWeekend'...
--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 28, 2014 at 7:56 am

#1732862
RE: Exploring Recursive CTEs by Example

David McKinney (7/28/2014)
Jeff Moden (7/25/2014)
David McKinney (7/17/2012)
I love it! Especially the conclusion.
It's time we stopped being afraid to whisper the words 'Recursive CTE' for fear of being...
--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 28, 2014 at 7:54 am

#1732857
RE: Frustration with Bad Design

From the article:
However it's usually not your company, and it's not your place to prove that there is a flaw in a system. It's especially true that it's not your...
--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 28, 2014 at 6:58 am

#1732808
RE: How to Handle Calculations Related to fiscal year and quarter

sslyle-1091060 (7/28/2014)
What if your period are 5-4-4?
Good question and would make for a good article to exploit the ISO_Week datepart (came out with 2008) of the datetime functions. 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)

July 28, 2014 at 6:14 am

#1732786
RE: How to Handle Calculations Related to fiscal year and quarter

g.britton (7/27/2014)
Much better to use a date dimension table that contains all relevant date info for your company. You can include columns like 'IsHoliday' or 'IsWeekend' as well as...
--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 28, 2014 at 5:58 am

#1732780
RE: Exploring Recursive CTEs by Example

It's funny... I didn't even see that I had responded to a 2 year old post.
Whether or not rCTEs are the right tool for a given problem or not,...
--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 28, 2014 at 5:25 am

#1732766
RE: Are the posted questions getting worse?

SQLRNNR (7/26/2014)
But the BS around rep just sucks.
That might be where the word "Overflow" comes from. 😛
--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 26, 2014 at 3:52 pm

#1732627
RE: How to find number of columns returned from query in powershell

@Chand00,
Two way street here... why do you want to do this in PowerShell? What is the purpose, 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)

July 25, 2014 at 7:24 pm

#1732567
RE: Are the posted questions getting worse?

Heh... isn't "reconciliation" how they found out that some BitCoin bank had been seriously whacked because the current balance wasn't immediately calculated to the penny? 😉
I'm with those that insist...
--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 25, 2014 at 6:20 pm

#1732562

Viewing 15 posts - 23,041 through 23,055 (of 59,067 total)