Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,501 through 37,515 (of 59,072 total)

RE: Math function question

CELKO (7/22/2010)
The underlying problem is that MONEY does rounding at every step (and only to 4 decimals and not the 5+ required for Euros). The rounding accumulates and screws 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)

July 24, 2010 at 9:15 am

#1197867
RE: Importing Tab Delimited Flat Files Using SSIS

Got a bit side tracked, yesterday. One does have to work for a living. 😀 Since you have the 32 bit environment, I can show you 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)

July 24, 2010 at 8:48 am

#1197864
RE: Cursor within DTS

LadyG (7/23/2010)
Thanks Chris, this is awesome. Will go ahead and include all the other required bits and see how I get on with it.
Thanks
Just to be absolutely sure, this calculation...
--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)

July 24, 2010 at 8:41 am

#1197862
RE: best practice question on providing calculations on the fly

chuck80 (7/22/2010)
Thanks. I thought about triggers but was concerned about the over head from the possible updates.
Didn't think about the option of a re-calculate flag.
The trigger would only calculate...
--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)

July 24, 2010 at 8:28 am

#1197859
RE: Are the posted questions getting worse?

Steve Jones - Editor (7/23/2010)
Speedo under the black ghost cloak...
GAH!!!! Now I have to jab out my mind's-eye! 😀
--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)

July 24, 2010 at 8:19 am

#1197858
RE: Are the posted questions getting worse?

Grant Fritchey (7/23/2010)
Lynn Pettis (7/23/2010)
Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown...
--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)

July 24, 2010 at 8:14 am

#1197857
RE: ?? After Rebuild!! I need to backlog with truncate and shinkfile but got the error "database in use". Why not???

nuengharit (7/22/2010)
Yep!!! I only use maintenance plan every month. But my space isn't enough.
I don't have budget to buy the new one. Please advise if i need to reduce sizing...
--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)

July 24, 2010 at 8:11 am

#1197856
RE: comparative stored procedure

sharonmtowler (7/23/2010)
i think they way i post my questions are fine.
In that case, Use Row_Number to number a the output of a CTE and perform a self join comparision with...
--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)

July 23, 2010 at 4:23 pm

#1197823
RE: spliting a varchar(max) into multiples

All those REVERSE's are likely to make that a pretty expensive proposition. Have you compared it on a a wide set of parameters?
--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)

July 23, 2010 at 4:19 pm

#1197822
RE: Sum Daily Data Into Weekly Data

Novicejatt (7/23/2010)
Hi
First of all Thankyou very much guys for ur help. Looks like its working.
Actually I'm importing data from a CSV file with BULK INSERT and the problem is that...
--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)

July 23, 2010 at 3:56 pm

#1197812
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Mike C (7/22/2010)
Jeff Moden (7/22/2010)
Mike C (7/22/2010)
Jeff Moden (7/22/2010)
Mike C (7/22/2010)
Obviously the so-called "buggy" execution plan requires the developer to be more careful, but gracefully handling invalid function parameter 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)

July 23, 2010 at 6:15 am

#1197454
RE: Sub query expressions vs. Joins.

Arjun Sivadasan (7/23/2010)
Arjun Sivadasan (7/22/2010)
Brian, Thanks for the article. I have a question here. I am not gonna post the DDL scripts as I have used your sample tables.
Consider 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)

July 23, 2010 at 6:04 am

#1197447
RE: Sum Daily Data Into Weekly Data

Joe Celko (7/22/2010)
Thank you for the DDL, but it stinks.
...
I can tell you never read a book on data modeling.
Heh... there ya go being all friendly like again,...
--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)

July 22, 2010 at 9:40 pm

#1197315
RE: Sum Daily Data Into Weekly Data

bteraberry (7/22/2010)
Jeff Moden (7/22/2010)
Wayne and BT...
Ummm... what happens if you're missing a week of data with either of your fine solutions? 🙂
Well, it depends! That would obviously be a...
--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)

July 22, 2010 at 9:00 pm

#1197309
RE: Sum Daily Data Into Weekly Data

Wayne and BT...
Ummm... what happens if you're missing a week of data with either of your fine solutions? 🙂
--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)

July 22, 2010 at 7:45 pm

#1197301

Viewing 15 posts - 37,501 through 37,515 (of 59,072 total)