Jeff Moden

Forum Replies Created

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

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
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

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