Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,456 through 40,470 (of 59,098 total)

RE: Why not Index Seek ?????????

Never mind...
--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)

December 29, 2009 at 6:16 am

#1096995
RE: Cummulative Totals By Dynamic Month Range

My other recommendation is that people like to test their solutions before posting them and, since you're probably under the gun won't have much of an appreciation for it just...
--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)

December 29, 2009 at 5:58 am

#1096988
RE: Cummulative Totals By Dynamic Month Range

tm3 (12/29/2009)
I made an attempt at modifying the code suggested to support the cummulative monthly networth table but I receive an error when I Execute the procedure -- Msg 102,...
--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)

December 29, 2009 at 5:56 am

#1096987
RE: Crash and Burn

Heh... I absolutely agree... all the backups in the world mean squat unless you can restore them. The DBA's a couple of jobs ago went through that. Took...
--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)

December 28, 2009 at 11:51 pm

#1096913
RE: when this error occurs ,how to find the problem?

Did you try what it told you to do?
--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)

December 28, 2009 at 11:45 pm

#1096911
RE: Cummulative Totals By Dynamic Month Range

I've got just the thing for ya...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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)

December 28, 2009 at 11:38 pm

#1096910
RE: Arithmetic overflow error converting datatype numeric to numeric

Heather May (12/28/2009)
Thanks for your replies, Jeff and Steve.
I did start trying to isolate the problem records and so far I've figured out that there's more than one record causing...
--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)

December 28, 2009 at 11:33 pm

#1096909
RE: Arithmetic overflow error converting datatype numeric to numeric

Steve Jones - Editor (12/28/2009)
It's definitely a data issue. As much as Jeff might not want to hear it, I think the quickest way to track down the data is...
--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)

December 28, 2009 at 11:32 pm

#1096908
RE: Arithmetic overflow error converting datatype numeric to numeric

Do you have an example of two numbers that you know caused the overflow error?
--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)

December 28, 2009 at 6:26 pm

#1096877
RE: Problem with Loading tables and views

It would propably help if you posted the actual errors you're getting.
--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)

December 28, 2009 at 4:34 pm

#1096867
RE: get value of variable

declare @year char(4)
Declare @visa varchar(25)
declare @visa1985 varchar(25)
set @visa ='56'
Set @year ='1985'
--select @visa = '@visa' + ''+@year+''
--Print @visa
--
--Exec('select '''+@visa+'''')
SELECT @Visa = @Visa+@Year
SELECT @Visa
--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)

December 28, 2009 at 4:28 pm

#1096866
RE: Are the posted questions getting worse?

Roy Ernest (12/28/2009)
Its fun once in a while to go around to shoot everything that moves...
Heh... reminds me of one of my favorite bumber stickers....
"I miss my first wife.... but...
--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)

December 28, 2009 at 3:49 pm

#1096859
RE: Are the posted questions getting worse?

I loved the old "brainless shoot something" games.... anyone remember the old Atari "River Raid" game or, a bit more recently, "Comanche"?
--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)

December 28, 2009 at 11:44 am

#1096781
RE: Need query

cthariharan (12/28/2009)
Thank you Jeff. I've added it. Let me know any improvements required.
Very cool and welcome aboard!
--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)

December 28, 2009 at 11:36 am

#1096778
RE: Need query

freeman.e.l (12/28/2009)
Jeff, I have to disagree please see the example below:
Your reebar example does not include the filter nid = nid. Also note, on smaller queries the optimizer will pull...
--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)

December 28, 2009 at 11:09 am

#1096772

Viewing 15 posts - 40,456 through 40,470 (of 59,098 total)