Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,286 through 30,300 (of 59,101 total)

RE: Replacement for Cursors

Chandrachurh Ghosh (4/26/2012)
There are always ways to avoid CURSOR.....but you might end up in a costlier plan.
If you have decided to use tally table.....try it out....
Unless someone uses a feature...
--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)

April 26, 2012 at 10:28 pm

#1480177
RE: Replacement for Cursors

vinu512 (4/25/2012)
OK...my bad...lets forget about printing the names.
I just want the names to be stored in 5 temp variables so that I can use them further.
Can that be done without...
--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)

April 26, 2012 at 10:20 pm

#1480174
RE: Are the posted questions getting worse?

dwain.c (4/26/2012)
You mean I gotta remember who and when?
I'm lucky sometimes if I can remember the day of the week.
Nope... just quote the thread by hitting the quote button instead...
--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)

April 26, 2012 at 9:35 pm

#1480163
RE: boolean value

post withdrawn
--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)

April 26, 2012 at 9:29 pm

#1480162
RE: Microsoft Certified Master

Robert Davis (4/25/2012)
I know that MSL is aware of this issue and I believe it has been escalated to Prometric
Wow! Seriously??? Who checks these things before they're promoted...
--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)

April 26, 2012 at 9:14 pm

#1480161
RE: Add varchar columns with colon in between to show time

dwain.c (4/26/2012)
Why don't you need (or want) the totals displayed as decimal hours so you can multiply them by rates easier?
I've always figured it's because blue-collar folk relate better 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)

April 26, 2012 at 8:58 pm

#1480158
RE: Add varchar columns with colon in between to show time

Using the same test data previously provided, I believe we can simplify a bit while doing a bit of grouping by date. This code will work in SQL Server...
--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)

April 26, 2012 at 8:28 pm

#1480154
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

TheSQLGuru (4/25/2012)
Hey Jeff, can you put a downloadable file with the relevant operational code parts of the post? Thanks in advance, and wonderful stuff as always!
If I understand correctly,...
--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)

April 26, 2012 at 6:01 pm

#1480134
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

I see what you mean. Same principle... just harder for some folks to see. Thanks, Craig.
--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)

April 26, 2012 at 5:58 pm

#1480133
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

GPO (4/25/2012)
The spam people clearly target the articles that everyone is going to read...
It's ironic that I have the SPAM people to thank for such a nice compliment. Thanks,...
--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)

April 26, 2012 at 7:23 am

#1479699
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

Cadavre (4/26/2012)
Nicely explained Jeff.
I may have to "borrow" your method of generating random DATETIME data, my method is more difficult to understand when people glance at it. 😀
Borrow away. ...
--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)

April 26, 2012 at 7:19 am

#1479695
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

TheSQLGuru (4/25/2012)
Hey Jeff, can you put a downloadable file with the relevant operational code parts of the post? Thanks in advance, and wonderful stuff as always!
Heh... stealing an idea...
--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)

April 26, 2012 at 7:15 am

#1479688
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

GPO (4/25/2012)
Superbly balanced article. But in true Oliver Twist fashion, "Can I have some more?"
In the real-world datetime data I've dealt with, they often follow roughly cyclical patterns, not pure...
--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)

April 26, 2012 at 6:57 am

#1479664
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

dwain.c (4/25/2012)
You da man Jeff! Another great article!
I've seen quite a few forum posts recently where your discussion of how DATETIMEs actually work would have assisted the posters had...
--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)

April 26, 2012 at 6:52 am

#1479655
RE: Generating Test Data: Part 2 - Generating Sequential and Random Dates

bitbucket-25253 (4/24/2012)
Thanks Jeff, another great article with code that everyone should add to their sandbox DB. And of course, use same, to test if an item is ready...
--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)

April 26, 2012 at 6:49 am

#1479652

Viewing 15 posts - 30,286 through 30,300 (of 59,101 total)