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

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

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

  • RE: Multi Column Sort

    sort on coalesce of all columns

  • RE: Are the posted questions getting worse?

    He's Cardinal Moden's pork chop holder.

    With a side order of bacon and humility :Wow:

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

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

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

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

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

  • RE: DateAdd Function

    YYYY-xx-xx will be interpreted as

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

  • RE: DateAdd Function

    is always YYYY-MM-DD when written this way

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

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

  • 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

  • RE: bcpin

    use [-F firstrow] of bcp ie -F2

    or FIRSTROW if using BULK INSERT

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