Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,916 through 36,930 (of 59,072 total)

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
RE: Are the posted questions getting worse?

Heh... and HELLLLLL NOOOO!!!! There's no way I'm setting up a Twitter account.
--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:06 pm

#1218344
RE: Are the posted questions getting worse?

Speaking of bull... I just signed up to do 2 sessions for SQL Saturday #60. What's up with the SQL Saturday site, anyway? The "blog" link goes 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 8, 2010 at 10:05 pm

#1218342
RE: Are the posted questions getting worse?

Alvin Ramard (9/8/2010)
Jeff Moden (9/8/2010)
Withdrawn... it was just a little too racy...
Too much bull? 😛
Yep... sometimes I forget that even though this is a water cooler forum, there are...
--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:00 pm

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

Craig Farrell (9/8/2010)
Please note the sample build code in the original post, where it shows that the first set of columns (for more then 8 fields) are in the most...
--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 9:51 pm

#1218340
RE: Are the posted questions getting worse?

Withdrawn... it was just a little too racy...
--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 9:45 pm

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

Your test code is working with Varbinary... not with Columns_Updated.
--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 12:27 pm

#1218165
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/8/2010)
I think more interesting is will The Thread beat me to 30k
I'm still trying to catch you as well. 😉
--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 11:57 am

#1218139
RE: An Informal Look at Database Performance

Well done, Timothy. Definitely "brief case" time for this article. Thanks for taking the time to make it so complete.
The idea of having a baseline and the idea...
--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 6:45 am

#1217888
RE: An Informal Look at Database Performance

mortenmaate (9/8/2010)
Thanks a lot for the great overview !
One thing I would like to mention additionally: Look a the SQL Server version. In my experience many companies upgrade their SQL...
--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 6:32 am

#1217883
RE: Table pivot

ioani (9/7/2010)
The solution I found for the problem:
-- Input data--
IF OBJECT_ID('#Params') IS NOT NULL
DROP TABLE #Params
CREATE TABLE #Params
(
ParameterID NVARCHAR(8) NOT NULL,
ParameterValue SQL_VARIANT...
--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 5:39 am

#1217856
RE: Table pivot

LutzM (9/7/2010)
Quite a while ago I thought using PIVOT would be, well... "cool".
After I figured how the syntax needs to be I was surprised that it didn't provide any performance...
--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 5:22 am

#1217847

Viewing 15 posts - 36,916 through 36,930 (of 59,072 total)