Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,506 through 47,520 (of 59,102 total)

RE: Need help generating a unique two letter alpha code for set based insert

dbaInTraining (10/31/2008)
I probably should have explained the reasoning behind the codes. This is for inventory part numbers and the table stores options that all parts can have. 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)

October 31, 2008 at 6:58 pm

#892640
RE: Need help generating a unique two letter alpha code for set based insert

john.steinbeck (10/31/2008)
I'm a bit confused, but check out my post I just posted and my other post, "Recursive"; I think that may be what you want...
Please post the correct URL.
--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)

October 31, 2008 at 6:57 pm

#892639
RE: T-SQL Code Optimizers

clive (10/31/2008)
What is the preferred option, with(nolock) or with(readpast).
What is the preferred option, if exists or if @@rowcount.
What is the preferred option, temporary table or derived table.
What is the preferred...
--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)

October 31, 2008 at 6:48 pm

#892638
RE: Please need help on looping through the dataset!!!

Garadin (10/31/2008)
3. Read the link in my signature for some tips on how to post data here for future questions. Had I had the information described in 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)

October 31, 2008 at 6:44 pm

#892637
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Jorge,
I flattered that you've mimiced the format I use for comments. And, they're pretty much what I would expect to see in a code review.
There are, however, a couple...
--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)

October 31, 2008 at 5:52 pm

#892633
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

jlcampos71 (10/31/2008)
I'll do that Jeff... but please let me know... where can I found information about it?
Yeaup... start by looking up "temporary tables [SQL Server]" (without the quotes) in Books...
--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)

October 31, 2008 at 5:29 pm

#892631
RE: Loop through a list of parameters to pass to a sproc

stacik (10/30/2008)
I have a sproc that has two parameters. It lives on a server which I only have remote access to. My manager runs the sproc to process a list...
--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)

October 31, 2008 at 11:06 am

#892474
RE: Field Type to use for Elapsed Time in HH:MM?

Heh... here's just some of the problems you can run into if you mess around with dates, times, and durations...
http://www.sqlservercentral.com/Forums/Topic595094-8-1.aspx
--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)

October 31, 2008 at 10:48 am

#892469
RE: Field Type to use for Elapsed Time in HH:MM?

Michael Valentine Jones (10/31/2008)
It’s usually better to store elapsed time in a datetime column as an offset from zero time, 1900-01-01 00:00:00.000. It then allows you to use 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)

October 31, 2008 at 9:45 am

#892424
RE: using CLR assembly

Jonathan Kehayias (10/30/2008)
As resistent as you are to CLR inside SQL, it is actually becoming more and more popular, even among MVP's for things just like this.
Heh... even though...
--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)

October 30, 2008 at 7:18 pm

#892138
RE: SQL Data Counter

You don't need a counter for that... just store a date on every row and then count the rows in a data range.
--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)

October 30, 2008 at 7:12 pm

#892137
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

jlcampos71 (10/29/2008)
Thanks Again Jeff!
I almost Figured that out... but I didn't at all... I was figuring out that I should make in fact, 3 passes, because there is a second...
--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)

October 30, 2008 at 6:46 pm

#892135
RE: Is a Recursive Query what I need?

No problem... thanks for the feedback.
--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)

October 30, 2008 at 6:35 pm

#892132
RE: Assigning current of _Cursor to local @variable

J (10/30/2008)
I am wondering WHY the HINT should be necesswary in the statement
UPDATE Products
SET @PrevF2 = F2 = CASE WHEN F2 IS NULL THEN @PrevF2...
--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)

October 30, 2008 at 6:26 pm

#892129
RE: Is a Recursive Query what I need?

Lynn Pettis (10/29/2008)
Jeff, I guess I should add that one to my sig block as well.
Seems like there have been a lot of reasons to use it, lately.
--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)

October 29, 2008 at 10:16 pm

#891598

Viewing 15 posts - 47,506 through 47,520 (of 59,102 total)