Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,071 through 23,085 (of 59,099 total)

RE: Do you usually go to agencies?

xsevensinzx (7/28/2014)
Lynn Pettis (7/28/2014)
xsevensinzx (7/28/2014)
Lynn Pettis (7/28/2014)
The problem with going to employers directly is actually knowing what employers are currently looking for talent. You can't always go be job...
--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:34 pm

#1733072
RE: Cross Join Help

dwilliscp (7/27/2014)
Jeff Moden (7/25/2014)
dwilliscp (7/25/2014)
I have a massive table (company, plant, resource, part number) that I need to create a from part number, to part number for every part within...
--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:12 pm

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

Viewing 15 posts - 23,071 through 23,085 (of 59,099 total)