Forum Replies Created

Viewing 15 posts - 1,411 through 1,425 (of 3,544 total)

  • RE: Multi Column Sort

    Oh, I agree. There will be another change in the rules. That's how this works. But it's keeping me mildly entertained at this point.

    mmmm, reminds me of a long...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Multi Column Sort

    Just for the record, if I was so condescending and thought I was so much smarter than everyone else, why would I be posting a question in the first place?...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Are the posted questions getting worse?

    I keep going on the second type because of the first type.

    I know what you mean :hehe:

    I posted a brief answer on the second just for the hell of it...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Multi Column Sort

    sort on coalesce of all columns

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Are the posted questions getting worse?

    He's Cardinal Moden's pork chop holder.

    With a side order of bacon and humility :Wow:

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Are the posted questions getting worse?

    Hey Bob! He's back!

    Well I hope not against the wall, people tend to get shot that way :crazy:

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Are the posted questions getting worse?

    I also joined Threadaholics Anonymous. We have support group meetings and give out pins.

    Thats OK, I'll inform your local Threadaholics Unanimous who will visit and get you to start posting...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: Are the posted questions getting worse?

    Quotes are acting all wonky...

    Nah! Must be the scotch :w00t:

    what am I going to hit?

    Not the thrusters too hard, you don't want to get dizzy and barf. Man that's got...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: ibrahim

    Not sure what the 'local' is supposed to be or where col1,col2 are but is this what you are trying to do ?

    SELECT col1,col2,l.colx

    FROM [localtable] l

    INNER JOIN OPENQUERY(LSname,'exec...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: DateAdd Function

    David: we are going off topic.

    Quite :ermm:

    I think we all agree that again we have a QoD which is not locale neutral.

    Yep 😉

    My post was not meant to cause...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: DateAdd Function

    YYYY-xx-xx will be interpreted as

    YYYY-MM-DD or YYYY-DD-MM depending on the connection's language setting

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: DateAdd Function

    is always YYYY-MM-DD when written this way

    I'll pretend you really did not write or mean that :crazy:

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: bcpin

    Based on your data your format file should be this

    8.0

    18

    1 SQLCHAR 0 4 "\t" 1 mis_year SQL_Latin1_General_CP1_CI_AS

    2...

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: bcpin

    Curious :ermm:

    I have used those parameters for such a purpose without any problems.

    Can you post your data structure, sample data and the format file

    Far away is close at hand in the images of elsewhere.
    Anon.

  • RE: bcpin

    use [-F firstrow] of bcp ie -F2

    or FIRSTROW if using BULK INSERT

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 15 posts - 1,411 through 1,425 (of 3,544 total)