Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,561 through 46,575 (of 59,101 total)

RE: Useful Dates: The Many Uses of Date Tables

rkonopka (12/17/2008)
Instead of double converting (first to varchar then back to datetime), wouldn't it be simpler and "cleaner" to do this:
select dateadd(dd,datediff(dd,0,getdate()),0)
Enjoyed the article
Yes... and faster to boot.
--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)

December 17, 2008 at 8:43 am

#913901
RE: The Full Potential of SQL 2000

rog pike (12/17/2008)
The great silicon dividend has been wasted. How can anyone gloat over all the bloat
Heh... man, do I agree with that! How many times have we heard...
--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)

December 17, 2008 at 8:41 am

#913899
RE: PIVOT vertical table without Aggregating

david.c.holley (12/16/2008)
Within that framework, the information that I provided would have been sufficient.
I'll be looking for a forum a bit more consistent with my prior experience so as not 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)

December 17, 2008 at 8:29 am

#913882
RE: Easy way

Forgive my ignorance... does that mean that the reporting server has "linked servers" to all the other servers or does that mean all the data from the other servers 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)

December 17, 2008 at 8:11 am

#913859
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

psmg01 (12/17/2008)
Hi Jeff,
I have a table that has the following values.
col1 | col2 | col3 | col4
1 | val1| val2 | val3
2 ...
--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)

December 17, 2008 at 8:08 am

#913855
RE: Useful Dates: The Many Uses of Date Tables

Brandon,
Not sure what the text editor you used may have done to you, but there's a lot of missing spaces in your code... for example CREATE TABLE has become CREATETABLE...
--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)

December 17, 2008 at 8:00 am

#913845
RE: Are the posted questions getting worse?

GilaMonster (12/16/2008)
I think he's a developer in over his head.
Heh... aren't they all?
--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)

December 17, 2008 at 12:08 am

#913633
RE: Are the posted questions getting worse?

RBarryYoung (12/16/2008)
Lynn Pettis (12/16/2008)
bitbucket (12/16/2008)
Jeff
I particularly liked ol' Bit Bucket's response... I'm gonna have to add him to the pork chop hall of fame.
Jeff should I be proud 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)

December 17, 2008 at 12:06 am

#913631
RE: Are the posted questions getting worse?

Steve Jones - Editor (12/16/2008)
I always wonder what those things mean next to the threads. I tend to ignore them.
Not sure I want a "twit" flag out there. As much...
--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)

December 17, 2008 at 12:05 am

#913630
RE: Are the posted questions getting worse?

Lynn Pettis (12/16/2008)
He's back..... But looks like he doesn't like our "requirements" for getting help and
I'll be looking for a forum a bit more consistent with my prior experience...
--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)

December 17, 2008 at 12:02 am

#913628
RE: Are the posted questions getting worse?

bitbucket (12/16/2008)
Jeff
I particularly liked ol' Bit Bucket's response... I'm gonna have to add him to the pork chop hall of fame.
Jeff should I be proud of this nomination 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)

December 17, 2008 at 12:00 am

#913627
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Dang it... I don't know how I missed your latest post on this, Lynn.
Heh... yeah... the concept can be used for a huge number of things. I remember seeing...
--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)

December 16, 2008 at 9:26 pm

#913573
RE: Easy way

Do you have "linked servers" setup on one server to access all the other servers? If not, and I have to ask, do you have the login information 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)

December 16, 2008 at 8:18 pm

#913550
RE: Are the posted questions getting worse?

Lynn Pettis (12/16/2008)
Jeff Moden (12/16/2008)
Lynn Pettis (12/16/2008)
Was that good enough over there? I hate it when I click on a link in an email notification and it dies.
Heh... gotta...
--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)

December 16, 2008 at 8:12 pm

#913548
RE: Are the posted questions getting worse?

GilaMonster (12/16/2008)
Here's another one that needs some help in asking questions. Not a twit, I just don't think he knows what he's after.
http://www.sqlservercentral.com/Forums/Topic620018-360-1.aspx
Heh... yeah... and he posts at almost 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)

December 16, 2008 at 8:01 pm

#913544

Viewing 15 posts - 46,561 through 46,575 (of 59,101 total)