Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,901 through 36,915 (of 59,072 total)

RE: Transform Data / Duplicate Records on the Fly

david.c.holley (9/9/2010)
The underlying goal is NOT to expand the number of days - taking a start date of 9/1 with an end date of 9/15 and creating records for 9/2...
--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)

September 9, 2010 at 3:42 pm

#1218941
RE: Transform Data / Duplicate Records on the Fly

HowardW (9/9/2010)
Jeff Moden (9/9/2010)
Actually, expanding to individual days would cause a lot of overhead. There's a better way but you're definitely on the right track.
Good point - didn't consider...
--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)

September 9, 2010 at 3:38 pm

#1218940
RE: Question: float display as character

Sharon S (9/9/2010)
Jeff and all,
Thanks for posting this response - it did the trick! SELECT UPPER(CONVERT(VARCHAR(30),@ReturnValue,2))
However, I don't understand why. Would you mind explaining if you have the time?
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)

September 9, 2010 at 3:35 pm

#1218938
RE: Linking to the Previous Row

Robert Carretta (9/9/2010)
David,
I have used Table Variables to accomplish the same thing. Are there a drawbacks to using table variables instead of CTEs? Are there advantages to using CTEs?
Table variables...
--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)

September 9, 2010 at 3:32 pm

#1218936
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/9/2010)
I should know in Oct if I can come. I'd like to. Allen is typically my roommate at places like the MVP Summit, so I'd like...
--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)

September 9, 2010 at 3:10 pm

#1218923
RE: Are the posted questions getting worse?

Alvin Ramard (9/9/2010)
Trey Staker (9/9/2010)
Steve Jones - Editor (9/9/2010)
Twitter is a lot like The Thread, only moving at a slightly faster pace.
You can sign up and just follow people, not...
--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)

September 9, 2010 at 3:05 pm

#1218917
RE: Columns_Updated() in update trigger reverses the bitmask?

Craig Farrell (9/9/2010)
Jeff Moden (9/8/2010)
Heh... whatever. My point is that BOL isn't wrong for the item I posted. 🙂
For the item you posted, no, but since we're discussing 2k5...
--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)

September 9, 2010 at 1:03 pm

#1218861
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/9/2010)
SQLSaturday is still transitioning from Andy and I to the PASS group and they're learning. Getting a new email setup for each event is a logistical...
--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)

September 9, 2010 at 12:46 pm

#1218857
RE: Are the posted questions getting worse?

AllenMWhite (9/9/2010)
Sorry about the confusion, folks. PASS is still setting things up. I posted the site link as soon as it was available. I'll let you know as soon...
--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)

September 9, 2010 at 12:42 pm

#1218853
RE: Transform Data / Duplicate Records on the Fly

Here's an easy way to do it in T-SQL. You could also pivot the result dynamically if you absolutely needed to. If you don't already have one or...
--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)

September 9, 2010 at 7:13 am

#1218571
RE: Transform Data / Duplicate Records on the Fly

david.c.holley (9/9/2010)
Its now a moot point as I've realized the better way to approach it on the ASP.NET side. However, I'm still curious about it for academic reasons.
I'd love 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)

September 9, 2010 at 6:28 am

#1218554
RE: Transform Data / Duplicate Records on the Fly

HowardW (9/9/2010)
The best way is to use a Tally or Date table and join to it where the date's between your date ranges to expand the date ranges into individual...
--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)

September 9, 2010 at 6:27 am

#1218551
RE: Are the posted questions getting worse?

Brandie Tarvin (9/9/2010)
So SqlSaturday60@sqlsaturday.com isn't working?
EDIT: Jeff, I just tried to email them for contact info. I'll let you know as soon as I hear anything back.
Thanks Brandie. It's...
--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)

September 9, 2010 at 5:47 am

#1218528
RE: Question: float display as character

Chris Morris-439714 (9/9/2010)
declare @returnvalue float
set @ReturnValue = ((6840844991.81 + 113664947.42) - (6947944500.34 + 2417617.57)) / (6947944500.34 + 2417617.57)
SELECT @ReturnValue --this is the correct calculated float number
-- truncate to 16dp
SELECT...
--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)

September 9, 2010 at 5:22 am

#1218509
RE: Question: float display as character

skcadavre (9/9/2010)
Lowell (9/9/2010)
Jeff Moden (9/8/2010)
Will this do?
SELECT UPPER(CONVERT(VARCHAR(30),@ReturnValue,2))
[/code]
I know there is usually a reason behind everything in your posts , Jeff...I love reading your posts specifically because I learn something...
--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)

September 9, 2010 at 5:17 am

#1218507

Viewing 15 posts - 36,901 through 36,915 (of 59,072 total)