Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,271 through 42,285 (of 59,102 total)

RE: How to Flatten Table Resultset

cos_ta393 (8/19/2009)
Jeff,
IT WORKS!!!!!! Thanks a million for your assistance; it is very much appreciated. Also my apology for giving Lutz credit for your articles and I want you 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)

August 19, 2009 at 6:33 pm

#1041913
RE: Are the posted questions getting worse?

GilaMonster (8/19/2009)
Party time next time I see my Lead (probably next week), I'll make sure he pays.
I scored best whiteboard session of the entire conference and best breakout session 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)

August 19, 2009 at 4:54 pm

#1041900
RE: Looking for advice on calendar scheduling

dsteinschneider (8/4/2009)
Long day here wrestling with a data migration. I printed out Jeff's posting suggestions - I'm putting together a post with the tables and what I have so far...
--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)

August 18, 2009 at 8:25 pm

#1041245
RE: Zero fill (Format) a field.

Ack... sorry... lost track of this one. Thanks for taking the time to post the reason for this. Legacy code is always a bugger.
--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)

August 18, 2009 at 8:19 pm

#1041244
RE: date function

Heh... stiffed again. As soon as they get their answer, they're off until the next time they need help.
--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)

August 18, 2009 at 7:11 pm

#1041239
RE: Are the posted questions getting worse?

Kit G (8/18/2009)
Jeff Moden (8/17/2009)[/b]
I guess that's part of what I mean... why wouldn't you correct the original blog?
I can think of one other reason not to edit the original...
--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)

August 18, 2009 at 6:43 pm

#1041234
RE: Are the posted questions getting worse?

Grant Fritchey (8/18/2009)
First & absolutely most important, it gave me a new blog post. Gotta have new things to blog about. But also, I don't like editing posts too 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)

August 18, 2009 at 6:32 pm

#1041232
RE: How to Flatten Table Resultset

Jeff Moden (8/18/2009)
cos_ta393 (8/18/2009)
3) Finally I reviewed Lutz's articles but this solution will be implemented against a 2000 engine
Thanks,
Heh... then the crosstab solution in both articles is perfect for you.
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)

August 18, 2009 at 6:19 pm

#1041231
RE: How to Flatten Table Resultset

lmu92 (8/18/2009)
b) the linked article I pointed you at is not mine so I don't deserve any credits for it... (right, Jeff? )
Actually, some good credit is due... you...
--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)

August 18, 2009 at 5:56 pm

#1041230
RE: How to Flatten Table Resultset

cos_ta393 (8/18/2009)
3) Finally I reviewed Lutz's articles but this solution will be implemented against a 2000 engine
Thanks,
Heh... then the crosstab solution in both articles is perfect for you.
Thanks for answering...
--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)

August 18, 2009 at 5:55 pm

#1041228
RE: How to Flatten Table Resultset

cos_ta393 (8/18/2009)
Jeff,
Thanks for pointing that out. The layout should look like:
cusid name product1 status ...
--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)

August 18, 2009 at 11:15 am

#1041026
RE: varchar(max) or varchar(some large number)?

paul.knibbs (8/18/2009)
Odd. Just ran that code against a SQL Server 2008 Express Edition database, and the VARCHAR(MAX) runs generally had higher CPU time but lower elapsed time than the VARCHAR(x)...
--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)

August 18, 2009 at 7:43 am

#1040859
RE: Table variables vs. temp tables, and should I use subqueries to minimize # of updates in these?

jeff (8/17/2009)
Jeff Moden - Oops, sorry, I thought you were being frivolous before; was kind of hard to tell what you meant. Thanks! I will check that out.
Heh......
--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)

August 17, 2009 at 9:00 pm

#1040613
RE: Are the posted questions getting worse?

Grant Fritchey (8/17/2009)
I don't know about integrity, but if I got it wrong, I got it wrong and it needs to be clarified. However, with a bit of help, I...
--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)

August 17, 2009 at 8:53 pm

#1040612
RE: Display Numeric Data in Scientific Notation

Just a hint...
SELECT -1.06E+3, ROUND(-1056,-ROUND(LOG(ABS(1.06E+3))/LOG(10),0,1)+2)
Of course, if you use that in a WHERE clause, there's no way an Index Seek will ever occur. The formula is deterministic so...
--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)

August 17, 2009 at 8:49 pm

#1040610

Viewing 15 posts - 42,271 through 42,285 (of 59,102 total)