Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,391 through 42,405 (of 59,067 total)

RE: Formatting issue with a calculated value

Heh... kewl. 🙂 In that case, I stand corrected.
--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 9, 2009 at 6:58 pm

#1036558
RE: Formatting issue with a calculated value

Do you know of anything that you can use in SELECT/INTO that will create a float column that isn't specifically cast as a float?
--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 9, 2009 at 6:34 pm

#1036553
RE: Formatting issue with a calculated value

Paul White (8/9/2009)
Jeff Moden (8/9/2009)
No need for rounding if you're going to cast the answer...
Hey Jeff,
Valid point, but let me explain myself: I left the ROUND in for two reasons:
1....
--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 9, 2009 at 6:14 pm

#1036549
RE: How to divide results into two somewhat-equal piles?

Paul White (8/9/2009)
(@Beverley: Jeff is kidding)
Heh... not quite. 😉
--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 9, 2009 at 6:12 pm

#1036548
RE: problem with query to update based on value in previous row

First of all, take a look at the article at the first link in my signature line at the bottom of this post. Then take a look at 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)

August 9, 2009 at 6:01 pm

#1036546
RE: problem with query to update based on value in previous row

RichSmith (8/9/2009)
Can anyone help me get this to work as a recursive query in SQL Server 2000?
Nope... but I can show you the right way. 😉 Gimme a couple...
--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 9, 2009 at 4:47 pm

#1036536
RE: hour and time dim

mesql (7/29/2009)
I have two time demission in my warehouse
One is the the time dim and the hour dim
In the time dim I have timeid, fulldate (2000-01-05 00:00:00.000) month...
--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 9, 2009 at 4:43 pm

#1036535
RE: Joining on view with a group by or distinct causes slow query

If you need all the columns from all 3 of the tables, I'm not sure you'll ever be able to make it as snappy as you'd like for a view......
--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 9, 2009 at 4:34 pm

#1036534
RE: Cant see the wood for the trees ! ...help on query please

Heh... I like the last line of that conversation except that's normally where I break out the pork chops with the bone in them. 😛 Getting back to 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)

August 9, 2009 at 4:25 pm

#1036533
RE: A script I was working on. Your thoughts and opinions?

Thanks for the feedback. 5.4 million rows, eh? If the solution I posted takes longer than, ummm... 40 seconds or so, post back... there's a little trick we...
--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 9, 2009 at 2:33 pm

#1036524
RE: Joining on view with a group by or distinct causes slow query

It doesn't necessarily help your current problem, I know you probably can't change it, and you may not even be concerned, but judging from the fact that you have more...
--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 9, 2009 at 2:12 pm

#1036522
RE: Becoming More Productive

Heh... my response would have been the same 5 years ago. 🙂
--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 9, 2009 at 1:58 pm

#1036521
RE: compare two column of a table

Nica,
I almost forgot... my code assumes that the values that are in the CODE column are unique. If they are not, then we really need you to post data...
--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 9, 2009 at 1:54 pm

#1036520
RE: Cant see the wood for the trees ! ...help on query please

Sorry... almost forgot... I suspect that the indexing you have will suffice although a covering index on just the columns in the first copy to the working table would actually...
--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 9, 2009 at 1:49 pm

#1036519
RE: Cant see the wood for the trees ! ...help on query please

Heh... "The devil's in the data", I always say. Sorry I missed the thing on PLNO = 4. I didn't spend much time with your code other than...
--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 9, 2009 at 1:46 pm

#1036518

Viewing 15 posts - 42,391 through 42,405 (of 59,067 total)