Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,816 through 52,830 (of 59,072 total)

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
RE: Performance of Scripts in SQL Server 2000

Ture enough... and I've not tried the SSIS solution for this, but (just something to consider) the DTS solution was horribly slow compared to the BULK INSERT that used 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 6:47 am

#769618
RE: Member Function Concept.

For the original problem given where certain parameters determine which function may be exercised and returned, a simple CASE statement would be in order whether it be for a RBAR...
--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:44 am

#769615
RE: How do I increment a DB id

Ok, thanks, Matt... good information. I'll get my arms around all this "new" 2k5 stuff, soon.
But I'm pretty sure that Scope_Identity isn't "login" sensitive as you suggest. That...
--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 10:49 pm

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

We'll see... when you figure out the correct answer for the real question being asked, post it here.
--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:56 pm

#769546

Viewing 15 posts - 52,816 through 52,830 (of 59,072 total)