Forum Replies Created

Viewing 15 posts - 44,791 through 44,805 (of 59,063 total)

  • 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

    ...

  • 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"...

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

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

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

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

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

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

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

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

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

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

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

  • RE: Question on following sql

    steveb (3/4/2009)


    nymgk_75 (3/4/2009)


    Hey Jeff,

    Thanks for the reply! I like your way also...

    Can you explain what the "U" is used for then? We didn't have that in the...

  • RE: Question on following sql

    beezell (3/4/2009)


    Good point Jeff. I almost put the word "Scope" in there for the dropping of temp tables, but I was afraid I would overcomplicate the explaination. Good...

Viewing 15 posts - 44,791 through 44,805 (of 59,063 total)