Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,831 through 52,845 (of 59,091 total)

RE: Date Check

Just curious... I can see where a NULL end date could be interpreted as 31 Dec 9999, but what does a NULL start date indicate other than something hasn't started?...
--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 18, 2008 at 11:04 am

#769800
RE: Format Date in SQL Table

GSquared (1/18/2008)
He's already mentioned that the column is being changed to datetime. He just wants to reformat it first (didn't say why). So, he's on the right track...
--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 18, 2008 at 10:59 am

#769798
RE: Running a Query Using a Text File for Input

Very good comprehensive article. I just don't understand why a simple BULK INSERT couldn't be used to populate a temp table...
--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 18, 2008 at 10:57 am

#769796
RE: How do I increment a DB id

If I remember correctly, @@IDENTITY has all the potential problems you describe including grabbing from the wrong table in the presence of triggers. I've never seen Scope_Identity fail 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)

January 18, 2008 at 8:20 am

#769690
RE: Member Function Concept.

No, no... you have to eat the boards if you use that 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)

January 18, 2008 at 8:15 am

#769683
RE: Combine 2 Text Fields??

Dang! You're spot on! I DO have better things to do than to help you. Thanks for the advice 😉
--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 18, 2008 at 8:11 am

#769678
RE: Member Function Concept.

OOOOHHHHHHHH!!! THAT 4-letter word! You're correct... it's a mortal sin to even speak it! 😛
I have a "special" oversize bat for that one... forgot all about it 'cause...
--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 18, 2008 at 7:38 am

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

Ah... understood...
I'm pretty new to 2k5 and don't have an answer for you. Guess that'll be a good thing for me to study over the weekend... permissions.
--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 18, 2008 at 7:33 am

#769651
RE: data dictionary tool

I laughed out loud when I saw your post above, Matt... I do understand that you have to use 20 or 30 pound porkchops to convince people of the right...
--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 18, 2008 at 7:31 am

#769650
RE: Combine 2 Text Fields??

Yeah... I do need to be a jerk about it... you wasted time by not posting in the correct forum and not telling us which version of SQL you were...
--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 18, 2008 at 7:20 am

#769641
RE: Member Function Concept.

Guess I havn't had enough coffee yet, Matt... which 4-letter instruction? Exec?
--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 18, 2008 at 7:17 am

#769638
RE: data dictionary tool

Nice one, Joe...
Even at that, the problem still remains... if a human doesn't take the time to establish a proper naming convention, proper DRI, and proper table/column commenting, although 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 18, 2008 at 7:15 am

#769637
RE: SQL6.5,7,2000 and 2005

Perhaps it's the language barrier, but it looked to me that you wanted us to give you all of the differences between the different versions for you to write 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 18, 2008 at 7:06 am

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

midan1 (1/18/2008)
i UNDERSTAND the code
That's the key... can't really speak for Matt but it was starting to look like you were having him debug every little thing without actually...
--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 18, 2008 at 6:59 am

#769624
RE: Performance of Scripts in SQL Server 2000

Whitt,
What I really want to know is that, although this was a great exercise for me personally, I did sort of bust a hump to give you a complete high-speed...
--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 18, 2008 at 6:49 am

#769619

Viewing 15 posts - 52,831 through 52,845 (of 59,091 total)