Forum Replies Created

Viewing 15 posts - 31 through 45 (of 128 total)

  • RE: Space missing in SELECT statement

    crussell-931424 (10/21/2013)


    I can't win on these. If you read it exactly as it is written then people complain that we should have understood what the question was really asking in...

  • RE: How to Post Performance Problems

    btcmalls74 (10/18/2013)


    Welcome to http://www.b2cmall.us//

    where is the most popular Panthers online shop.

    ((( http://www.b2cmall.us/ )))

    lower price fast shippment with higher quality!!

    WE ACCEPT CREDIT CARD /WESTERN...

  • RE: UNION Query help

    Luis Cazares (10/18/2013)


    ScottPletcher (10/18/2013)


    T.Ashish (10/17/2013)


    Jeff Moden (10/17/2013)


    ScottPletcher (10/17/2013)


    Or just:

    ORDER BY 1

    I often avoid using the column names at all in UNIONed queries, as the names somehow seem to

    change a...

  • RE: DEFAULT

    nice one

  • RE: Grow Your Family

    Is there any group in India ?

  • RE: Grow Your Family

    You might find a new good friend, a contact that you can call for help, or a colleague that calls to offer you a new job.

    Actually the last line...

  • RE: Parameter sniffing

    Maximum wrong reply on this question

  • RE: UNION Query help

    Jeff Moden (10/17/2013)


    ScottPletcher (10/17/2013)


    Or just:

    ORDER BY 1

    I often avoid using the column names at all in UNIONed queries, as the names somehow seem to

    change a lot 🙂 :

    Thank goodness...

  • RE: UNION Query help

    Good. Now OP has many ways to order his UNION query.

  • RE: UNION Query help

    Greg Edwards-268690 (10/17/2013)


    It looks like you have 5 columns in 1 query and 4 in the other.

    No, Both has 4 columns.

  • RE: Transaction

    Bhuvnesh (10/17/2013)


    L' Eomot Inversé (10/16/2013)


    Bhuvnesh (10/16/2013)


    But I made the wrong selection . beacuse i was thinking (and this was my understanding ..earlier) that once the commit has been fired, the...

  • RE: UNION Query help

    Pulivarthi Sasidhar (10/16/2013)


    use ORDER BY CboValuesTranslations.cboValueTranslationName Asc

    for 1st Select statement and then use union with 2nd select statement.

    You will get error "Incorrect syntax near the keyword 'union'."

  • RE: UNION Query help

    Change

    ORDER BY CboValuesTranslations.cboValueTranslationName Asc

    with

    ORDER BY Name Asc

  • RE: Sequence

    easy

  • RE: ISNUMERIC(varchar)

    Why it returns 1 ?

Viewing 15 posts - 31 through 45 (of 128 total)