Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,846 through 52,860 (of 59,072 total)

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
RE: Simple Query I Need.....

Answer the question, Sandy... what do you need this for? "Its one of the requirement" isn't an answer. It's homework, isn't 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)

January 16, 2008 at 11:49 pm

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

Actually, this looks like a standard "factorial" homework problem. What do you need this for?
--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 16, 2008 at 11:22 pm

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

midan1 (1/16/2008)
how to generate date backward from end to start
like this
begin
-- loop to insert date backward
while
@end_date>=@start_Date
begin
INSERT INTO @tb_temp
from middle of the month to end of the month
serial date
------------------------------
1 19/03/2008
2 18/03/2008
3...
--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 16, 2008 at 10:56 pm

#769068
RE: Performance of Scripts in SQL Server 2000

Squirrel and S. Blvd...
We should get together sometime and do a couple of 12 oz. curls...
--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 16, 2008 at 9:58 pm

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

David Jackson (1/15/2008)
You can use a function with no cursor for this...
Nicely done, Dave...
--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 16, 2008 at 9:08 pm

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

PW (1/15/2008)
With SQL2K, the only way to avoid cursor (or 'hidden' cursor in a function) is to accept a non-dynamic query where the number of lines of text queried 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 16, 2008 at 9:02 pm

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

Wayne West (1/15/2008)
I spent a good amount of time putting together my original post, it's too complicated a system not to include enough detail so that people can duplicate what...
--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 16, 2008 at 9:00 pm

#769050
RE: Please help on a simple query

Good luck with that... does TeraData use the same date functions as T-SQL?
--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 16, 2008 at 8:53 pm

#769049
RE: Using 'OR' drastically increases execution time of query?

Hey Kevin Boles! Here's your chance, buddy... show us what you've got! 😉
--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 16, 2008 at 8:49 pm

#769048
RE: when using multiple unions get Only the first query in a UNION statement can have a SELECT with an assignment

The error occurs because a variable can contain only one value... the unions return more than 1 value.
The option of using a table variable is good.
--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 16, 2008 at 8:43 pm

#769047
RE: Left Outer Join/Group By

Ummm.... wanna tell us what your mistake was, please?
--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 16, 2008 at 8:14 pm

#769042

Viewing 15 posts - 52,846 through 52,860 (of 59,072 total)