Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,821 through 44,835 (of 59,095 total)

RE: how can i avoid cartesian join?

Heh... it's easy and I'll tell you... right after you tell me why you'd want to do such a thing... you know... what are the business requirements that require this...
--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)

March 4, 2009 at 10:52 pm

#953790
RE: BCP Format File

bicky1980 (3/4/2009)
Hello
Is anyone able to send me an example of a Format file to be used in conjuction with the BCP command to create a comma delimited text file which...
--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)

March 4, 2009 at 10:47 pm

#953787
RE: BCP Format File

daredon28 (3/4/2009)
Hi,
For Exporting data
bcp AdventureWorks.Sales.SalesOrderDetail out c:\Currency.txt -c -S student\sqlserver2005
Use IN instead of OUT to import data
...
--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)

March 4, 2009 at 10:45 pm

#953786
RE: Find out duplicate rows from multiple table

... and, no... sorry... I don't know how to write a script to do it for 300 different tables auto-magically... no way to know which columns make up the "duplicate"...
--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)

March 4, 2009 at 10:40 pm

#953784
RE: Find out duplicate rows from multiple table

SQL_Quest (3/4/2009)
beezell (3/4/2009)
This sounds like a bit of a complex problem. The issue will be that each table has a different column that will identifiy it as being duplicated....
--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)

March 4, 2009 at 10:33 pm

#953779
RE: Can any one tell me?

saravanantvr1984 (2/26/2009)
how can we convert date(2009-02-26) format to this format Twenty-Second May Nineteen Nineteen Eighty Two?
is it possible in 2000/2005?
Heh... two way street here... why do you need to do...
--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)

March 4, 2009 at 8:03 pm

#953735
RE: Split string field based on character position

gresford (3/2/2009)
Thanks everyone! I greatly appreciate the help. Now I have a few options to try.
Actually, I'd avoid any that use a Recursive CTE or While loop as...
--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)

March 4, 2009 at 7:32 pm

#953734
RE: question, urgent please!!!

Heh... guess we're not gonna find out "why" on this one... I wish that people would finally figure out that this is a two way street.
--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)

March 4, 2009 at 7:18 pm

#953732
RE: HELP ME

John Mitchell (3/4/2009)
And don't worry about sounding demanding - I'll always give you the benefit of the doubt if English isn't your first language.
Good... you can have them all... I...
--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)

March 4, 2009 at 7:01 pm

#953731
RE: Select distinct row on SQL 2000. Please help me!

tuyetmuadong (3/3/2009)
This result is my demo. Actually, we can get (2, TRG, TFS) or (2, DFG, EFB). That is ok. I only care value of LINK field, I don't care...
--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)

March 4, 2009 at 6:54 pm

#953730
RE: The February 2009 Energy Update

Luke L (3/4/2009)
no, but liquid nails works adequately well for these types of applications.
Heh... So does two short nails.
--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)

March 4, 2009 at 6:05 pm

#953725
RE: Are the posted questions getting worse?

Grant Fritchey (3/4/2009)
This post has a bit irony attached I think:
http://mangalpardeshi.blogspot.com/2009/03/how-to-disable-right-click-on-your-blog.html
10 pounds worth...
--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)

March 4, 2009 at 4:46 pm

#953701
RE: Are the posted questions getting worse?

Derek Dongray (3/4/2009)
I skimmed over most of Mangal's blog posts and felt that there wasn't much there which I hadn't come across elsewhere. Nothing wrong with that really (although 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)

March 4, 2009 at 4:33 pm

#953696
RE: Are the posted questions getting worse?

bitbucket (3/4/2009)
heck it is their culture.
I hate people that won't adapt and that think the world needs to kiss their hiney just cuz they were spawned from the right set...
--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)

March 4, 2009 at 4:29 pm

#953692
RE: Query for "as of Date"

Grant Fritchey (3/4/2009)
I always forget they're there when I post. Makes me crazy.
:D:P;):w00t::cool::hehe:
Heh... I don't get it... remember when they fixed it so spaces would be preserved? They just...
--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)

March 4, 2009 at 4:23 pm

#953687

Viewing 15 posts - 44,821 through 44,835 (of 59,095 total)