Forum Replies Created

Viewing 15 posts - 1 through 15 (of 257 total)

  • RE: Wildcards II

    Thanks for easy and back to basic question 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    December 3, 2013 at 2:29 am

    #1670299

  • RE: Datefirst

    Thanks 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    September 12, 2013 at 11:28 pm

    #1649935

  • RE: wildcards

    Toreador (9/11/2013)

    Dear Steve

    Can you change the points system so that if someone replies pointing out an error and 8 pages of people have already replied pointing out the same error...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    September 11, 2013 at 7:10 am

    #1649280

  • RE: wildcards

    Hany Helmy (9/11/2013)

    I am really amazed of the 16 people (as of now) who got it right! :w00t:

    Hope one of them will post a reply explaining how he got the...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    September 11, 2013 at 12:36 am

    #1649111

  • RE: wildcards

    handkot (9/10/2013)

    I got an error: "String or binary data would be truncated. The statement has been terminated."

    (0 row(s) affected);-)

    Just because of "Steppenwolf" having length 11. So insert statement is...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    September 10, 2013 at 11:15 pm

    #1649097

  • RE: Behavior of trigger

    Thanks for back to basics. Good question 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    September 9, 2013 at 11:33 pm

    #1648711

  • RE: CASE vagaries

    Hugo Kornelis (9/7/2013)The actual answer is "@X is now A<". That's because the author uses ISNULL instead of the recommended COALESCE. ISNULL does not follow the normal data type precedence...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    September 9, 2013 at 12:29 am

    #1648442

  • RE: Holiday Breaks

    Hany Helmy (9/1/2013)

    Maybe this is the easiest question ever in SSC; thanx Steve 😀

    +101:-D:-D:-D

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    September 2, 2013 at 1:22 am

    #1646676

  • RE: Global Configuration Settings

    Stewart "Arturius" Campbell (8/30/2013)

    Interesting question, thanks Sean

    +1 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    August 30, 2013 at 4:10 am

    #1646280

  • RE: NTILE

    Easy and good one 😀

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    August 28, 2013 at 11:33 pm

    #1645831

  • RE: SQL Server Tables

    Thanks for start my day with easiest question 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    August 26, 2013 at 11:37 pm

    #1645007

  • RE: Transaction Trio

    Good back to basic question. Thanks 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    August 25, 2013 at 11:24 pm

    #1644788

  • RE: Normal Forms and Data Integrity

    Tough question for me. :blink:

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    August 22, 2013 at 11:11 pm

    #1644245

  • RE: CONCAT 1

    Carlo Romagnano (8/22/2013)

    In this case CONCAT also is faster than ISNULL(FirstName + ' ', '') + ISNULL(MiddleName + ' ', '') + ISNULL(LastName + ' ', '') + ISNULL(CONVERT(VARCHAR(3), Age),'')

    Because...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    August 22, 2013 at 7:36 am

    #1643916

  • RE: CONCAT 1

    If you already use CONCAT function then it's easy to you. Otherwise first you need to check about CONCAT function.

    I love this function. It removes some overhead while adding multiple...

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

    August 21, 2013 at 11:29 pm

    #1643753

Viewing 15 posts - 1 through 15 (of 257 total)