Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,866 through 50,880 (of 59,098 total)

RE: IT salary is going down !

Cool! (Sorry... no pun intended). You really got around! (Dang, did it again! :D)
It's a shame they retired the Sturgeon class... good, quiet, fast platform. 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)

April 30, 2008 at 7:33 pm

#809402
RE: cursor through user databases the SEQUEL

Couple of things...
First, 'DataBase_Version' does not exist in SysObjects unless you created a table or something called 'DataBase_Version'. What is 'DataBase_Version'????
Second, look at you IF statement in the dynamic...
--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)

April 30, 2008 at 7:26 pm

#809401
RE: Create a Tally or Numbers Table

And you actually believe in the myth of code portability? That'll only happen when no one creates their own extensions to the ANSI standards. 😛
--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)

April 30, 2008 at 7:16 pm

#809398
RE: Create a Tally or Numbers Table

But, it is a Tally table... it's used to count. And, besides... as you've already found out ol' friend... Tally is not likely to ever be a reserved word....
--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)

April 30, 2008 at 7:05 pm

#809396
RE: IT salary is going down !

Jason Selburg (4/30/2008)
Now that's funny! I used to listen to fish farts on the USS Silversides (SSN 679) & USS Jacksonville (SSN 699) back in '89.
I wonder how many...
--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)

April 30, 2008 at 7:00 pm

#809393
RE: I need to add the last day of the month to a result from a column containing only year and month

shamshudheen (4/2/2008)
Jeff
the query you posted is throwing error "Operand type clash: INT is incompatible with DATETIME "
Then, you're done something wrong... Int IS compatabible with DATETIME in 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)

April 30, 2008 at 6:52 pm

#809392
RE: How to update, in a table, all the columns with a name that begins with the same string (same value for all)

Heh... yeah... You're right and I agree... except I don't allow garbage names into the server. :hehe:
--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)

April 30, 2008 at 6:38 pm

#809389
RE: Blackle

Thanks, Steve... I'll take a look. One test is worth a thousand guesses...
I still like the ultimate power saver... turn it off when you're not using it. 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)

April 30, 2008 at 9:18 am

#809140
RE: Create a Tally or Numbers Table

Thanks guys... I sure do appreciate your feedback.
I just got word that it's coming out on May the 7th.
--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)

April 30, 2008 at 9:15 am

#809135
RE: IT salary is going down !

I agree, nothing beats experience...
--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)

April 30, 2008 at 9:14 am

#809132
RE: Row-By-Row Processing Without Cursor

See the following URL... almost identical situation...
http://www.sqlservercentral.com/Forums/Topic491969-149-1.aspx#bm492576
--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)

April 30, 2008 at 9:10 am

#809123
RE: difference

Mahesh Bote (4/30/2008)
[font="Verdana"]
... and, just to be sure, you can do INSERTs, UPDATEs, and DELETEs on Table Variables in a UDF... just not on external tables.
Jeff, I was talking about...
--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)

April 30, 2008 at 9:08 am

#809120
RE: Combine multiple rows

Yeah... I agree... if it's a return to the GUI, the comma separated list would probably be the way to go for the very reasons you stated. 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)

April 30, 2008 at 9:07 am

#809119
RE: Blackle

Steve Jones - Editor (4/30/2008)
On CRTs, to product light takes energy, black is less power.
On LCDs, all colors require energy, so Blackle doesn't really help, especially over time. It was...
--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)

April 30, 2008 at 9:04 am

#809117
RE: Blackle

Adrian Nichols (4/30/2008)
Jeff,
Here's a link to Googles Earth Hour effort....
http://www.google.co.uk/intl/en_uk/earthhour/
And this one's for the official blog saying that it may actually use more energy!
http://googleblog.blogspot.com/2007/08/is-black-new-green.html
Thanks, Adrian!
--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)

April 30, 2008 at 9:00 am

#809114

Viewing 15 posts - 50,866 through 50,880 (of 59,098 total)