Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,861 through 52,875 (of 59,098 total)

RE: Combine 2 Text Fields??

jkurtis (1/17/2008)
theres a couple problems with that.
The 1st is that I'm on SQL2000.
And people wonder why I get ticked at some users... what were you thinking when you posted this...
--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)

January 17, 2008 at 9:10 pm

#769537
RE: What are the essential PERMISSION GRANTS for making a FUNCTIONAL SQL database ?

I'm thinking "simple answer" here... what were the grants on the old box?
--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)

January 17, 2008 at 9:05 pm

#769535
RE: Format Date in SQL Table

Changing the format of the "date" column is just a repetitition of the original mistake... for more reasons than will fit in this meager window, you must NEVER store dates...
--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)

January 17, 2008 at 9:03 pm

#769534
RE: data dictionary tool

Quick show of hands... how many require that table and column comments be included in table definitions? Next question... How many require that they be done correctly? 😉
--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)

January 17, 2008 at 8:44 pm

#769530
RE: help-how to generate date backward from end to start

I wondered when you were going to get to that point...
--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)

January 17, 2008 at 8:08 pm

#769525
RE: Why deadlocks occuring when I have @@lock_timeout set to -1 (infinite wait) ???

Daniel Storm (1/17/2008)
OK, based on the two posted responses thus far, some more clarification regarding my question is obviously required …
- I’m not asking about what a deadlock is (been...
--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)

January 17, 2008 at 7:57 pm

#769522
RE: Need help replacing a cursor with set-based code (if possible!)

Ah... sorry... I see what you're getting at, now... yes, you are correct... only way to trully avoid the RBAR of the function is to, in fact, limit to a...
--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)

January 17, 2008 at 7:43 pm

#769520
RE: Stripping out double quotes (") in bulk insert

A format file example would be great 🙂
Yeah, huh? You expect us to guess what the record layout and target table schema 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)

January 17, 2008 at 7:25 pm

#769517
RE: Member Function Concept.

Sandy (1/17/2008)
Jeff,
Can you Please Look into this topic?
Cheers!
Sandy.
Another obvious cheat, Sandy?
--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)

January 17, 2008 at 7:21 pm

#769516
RE: Simple Query I Need.....

Sandy (1/17/2008)
Hey sqluser,
Thanks, It is working...
Jeff,
Actually I asked about this post...
" http://www.sqlservercentral.com/Forums/Topic444141-338-1.aspx "
Jeff,
-------------
Sandy learned nothing about what Sandy was supposed to learn... except how to cheat. Great job, Pal!...
--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)

January 17, 2008 at 7:17 pm

#769515
RE: data dictionary tool

I'm thinking that there's a lot of people that don't understand what a good data dictionary is nor how it's made. Regardless of the tool involved, without intelligent 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)

January 17, 2008 at 7:07 pm

#769512
RE: help-how to generate date backward from end to start

ALZDBA (1/17/2008)
btw the common table expression I like most is a round of beers :w00t:(expressing friendship). :smooooth:
Definitely a kindred spirit... round of beers... motorcycle for an avatar...
--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)

January 17, 2008 at 7:03 pm

#769511
RE: Simple Query I Need.....

sqluser (1/17/2008)
Hi Sandy,
Try out this ....
SELECT EXP(SUM(LOG(SID))) FROM #t
😛
Man, some people just don't get it... Who's goin' for 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)

January 17, 2008 at 12:56 am

#769097
RE: Simple Query I Need.....

What other post? Post the URL so I don't have to look for it. 😉
On the homework, the method that Adam is leaning towards is not the method your...
--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)

January 17, 2008 at 12:41 am

#769095
RE: Simple Query I Need.....

Sandy (1/17/2008)
Jeff,
he he he..lolz...:P ....
Now you will tell me....hee hee ..in my shop.....;)
Please Tell me the Answer,
Jeff, Is it possible or Not?
Please ....
Cheers!
Sandy.
Heh... in my shop, I tell people...
--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)

January 17, 2008 at 12:20 am

#769088

Viewing 15 posts - 52,861 through 52,875 (of 59,098 total)