Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,931 through 36,945 (of 59,098 total)

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
RE: Question: float display as character

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 (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)

September 9, 2010 at 5:16 am

#1218506
RE: Are the posted questions getting worse?

Seriously... I need to contact someone running the SQL Saturday #60 event in Cleveland and the even email won't take an email from me. It doesn't like my provider....
--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:11 am

#1218502
RE: Are the posted questions getting worse?

David Burrows (9/9/2010)
Jeff Moden (9/8/2010)
Heh... and HELLLLLL NOOOO!!!! There's no way I'm setting up a Twitter account.
What!! You mean you're not a twit already heh! 😛
Heh... "Twit 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 5:08 am

#1218499
RE: Question: float display as character

Will this do?
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
SELECT UPPER(CONVERT(VARCHAR(30),@ReturnValue,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 8, 2010 at 10:25 pm

#1218348

Viewing 15 posts - 36,931 through 36,945 (of 59,098 total)