Jeff Moden

Forum Replies Created

Viewing 15 posts - 53,431 through 53,445 (of 59,072 total)

RE: Isnull function

Apparently not... I've still not seen the correct answer from Karthik.
--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 22, 2007 at 8:29 am

#762390
RE: Palindrome-SQL

Karthik,
This is what I spoke of on one of the other posts... it's also why people get so angry with you. You banter the "Senior Software Engineer" label all...
--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 21, 2007 at 11:36 pm

#762382
RE: How to improve SET-BASED Logic?

Grant is spot on... If you want to avoid RBAR, stop thinking RBAR. The key or "secret" to that is to never ever think about what you want 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)

December 21, 2007 at 11:24 pm

#762380
RE: The December Energy Update

Now, that's quite an article... some great references, too! Thanks for the research, Steve.
--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 21, 2007 at 9:23 pm

#762375
RE: Extract data to another table?

Yes, there is a "secret"... simply think about what you want to do to columns instead of what you want to do to rows. That and having a little...
--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 21, 2007 at 9:20 pm

#762374
RE: Isnull function

Now, thats a "hint" if I ever saw one... 😉
--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 21, 2007 at 8:26 pm

#762370
RE: Pivot? Function? Complex results required

Jason Selburg (12/21/2007)
No problem Jeff! I'm really starting to se the true value of the Tally table BTW.. 😀
Hey, you never answered my PM.
Heh... another compliment. Thanks, Jason, 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 21, 2007 at 8:16 pm

#762367
RE: Pivot? Function? Complex results required

(Good to see you're starting to like some of the new tricks out there Jeff!)
Shoot... once I learned it, I was just aching for a place to use it! ...
--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 21, 2007 at 8:11 pm

#762366
RE: Delete and Insert Blocking

Troy Doherty (12/21/2007)
By deleting records < select @dt = datediff( d, -94, getdate()) i would have deleted all of my data.....:w00t:
Heh... Troy, you must have a death wish... testing deletes...
--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 21, 2007 at 8:01 pm

#762365
RE: Pivot? Function? Complex results required

That's quite a compliment, Jason. Thanks. Glad to see someone take it to the next level by actually getting a better job from what they're learned by looking...
--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 21, 2007 at 6:11 pm

#762357
RE: bcp a file having five columns and subcolumns (not fixed in each row) in its first column in a table .

Unless the "spaces" between the columns are something besides spaces, then you can't use BCP to import this file because the country names may also have spaces.
--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 21, 2007 at 6:08 pm

#762356
RE: Adding a dynamic incremental column

The best answer for SQL Server 2000 is, in fact, the Temp Table solution. It's nasty fast, especially if you use a SELECT/INTO.
The solution that Absinthe showed ...
select (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)

December 21, 2007 at 6:04 pm

#762355
RE: CURSOR v WHILE for beginners

The seed should probably the value returned from the NextID proc...
Other problem is, you have to increment the NextID in the NextIDtable by the number of rows you have in...
--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 21, 2007 at 1:15 pm

#762311
RE: Pivot? Function? Complex results required

Think of it as a "going away present", Jason. Good luck on your new job!
--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 21, 2007 at 1:06 pm

#762307
RE: Stored Proc Help

There's no need to convert to a number and then back to a date if the data is just being used in a WHERE clause... for example... a modification of...
--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 21, 2007 at 1:03 pm

#762305

Viewing 15 posts - 53,431 through 53,445 (of 59,072 total)