Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,416 through 38,430 (of 59,072 total)

RE: Help with Query

elutin (5/12/2010)
"Quirky Update" way
Here we are:
1. I would not use it if I would be you.
2. If you deside to use it, you must read
"The RULES" section...
--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)

May 12, 2010 at 9:46 pm

#1166612
RE: Code generation

scziege (5/12/2010)
Hey Jeff,
our customer want to make a promotion on a product package with this codes.
The customer can buy the product and insert the code onto a web page, after...
--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)

May 12, 2010 at 9:07 pm

#1166605
RE: Do you know your getdate()?

Joe Celko (5/12/2010)
I just wish that Microsoft has used the ISO/ANSI Standard CURRENT_TIMESTAMP and CURRENT_DATE instead of more dialect. Of course, they are going to have trouble with TIMESTAMP(n) 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)

May 12, 2010 at 3:55 pm

#1166565
RE: checkning for allowable values

Yes and no. You're certainly on the correct tract with making a table but it should be a permanent table instead of one built on the fly. Second,...
--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)

May 12, 2010 at 3:16 pm

#1166553
RE: CTE performance

The one in probably the most famous article ever when it comes to how to do things using "Nested Set" hierarchies... written by none other than Joe Celko himself...
http://intelligent-enterprise.informationweek.com/001020/celko.jhtml;jsessionid=SDL2T2BF3SLWFQE1GHPSKH4ATMY32JVN
I'll also...
--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)

May 12, 2010 at 3:11 pm

#1166550
RE: checkning for allowable values

Joe Celko (5/12/2010)
Don't use the race codes table; remove the code from the string and see if it has left-overs:
REPLACE('I', '',
REPLACE('N', '',
REPLACE('P', '',
REPLACE('B', '',
REPLACE ( 'W', '', mutli_race_code),
),),),)...
--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)

May 12, 2010 at 1:55 pm

#1166509
RE: checkning for allowable values

lmu92 (5/11/2010)
Jeff Moden (5/10/2010)
As much as I love working with the Tally table, it just doesn't need to be that complicated for this. In fact, the CASE formula in...
--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)

May 12, 2010 at 1:51 pm

#1166506
RE: CTE performance

Heh... see Kazim? I'm not the only one that want's a piece of your "architect". 😉
--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)

May 12, 2010 at 1:08 pm

#1166485
RE: Views Vs Stored Procs

CirquedeSQLeil (5/12/2010)
GilaMonster (5/12/2010)
It depends.
p.s. A 5-table query is not exactly complex.
Agreed.
Heh... it depends. 😛
--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)

May 12, 2010 at 12:58 pm

#1166480
RE: Code generation

scziege (5/12/2010)
Hey Jeff,
our customer want to make a promotion on a product package with this codes.
The customer can buy the product and insert the code onto a web page, after...
--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)

May 12, 2010 at 8:07 am

#1166230
RE: Code generation

Gianluca Sartori (5/12/2010)
Great explanation, Jeff! That's one thing I wanted to ask.
It's strange to see that partition by seems to be faster than distinct. I would have expected 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)

May 12, 2010 at 8:02 am

#1166221
RE: Comparing two rows in one table for changes in column

Dobermann (5/11/2010)
Wow, Jeff! I am going to have to study this one long and hard! Thank you so much - I will post back with either more questions...
--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)

May 12, 2010 at 7:36 am

#1166198
RE: Comparing two rows in one table for changes in column

dmoldovan (5/12/2010)
Dobermann, Jeff, I appologize for being wrong this time. I did not realized in a timely manner the output that Dobermann needs.
Sorry, guys :blush:
Nah... you're alright. I very...
--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)

May 12, 2010 at 7:03 am

#1166165
RE: Comparing two rows in one table for changes in column

The "4th row" does complicate things a bit. You have to reverse the query and run it again and then get rid of the dupes... I think this will...
--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)

May 11, 2010 at 10:42 pm

#1165943
RE: Comparing two rows in one table for changes in column

Dobermann (5/11/2010)
Jeff Moden (5/11/2010)
Heh... you do realize that by using the 2008 VALUES clause, that all of the people still stuck in the world of 2005 or earlier either can't...
--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)

May 11, 2010 at 9:07 pm

#1165930

Viewing 15 posts - 38,416 through 38,430 (of 59,072 total)