Timestamps

  • honza.mf

    SSCertifiable

    Points: 5519

    Comments posted to this topic are about the item Timestamps



    See, understand, learn, try, use efficient
    © Dr.Plch

  • Hany Helmy

    SSChampion

    Points: 13435

    I think the answer is wrong as statement #7 runs succesfully and returns 0 rows & also statements #8 run succesfully and didn`t fail for any reason!!

    Any explanation dear author?!! :cool:;-)

  • honza.mf

    SSCertifiable

    Points: 5519

    hany.helmy (5/5/2013)


    I think the answer is wrong as statement #7 runs succesfully and returns 0 rows & also statements #8 run succesfully and didn`t fail for any reason!!

    Any explanation dear author?!! :cool:;-)

    Did you run it as a batch or as separate statements? Question is written as a single batch.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • Ron McCullough

    SSC Guru

    Points: 63877

    Nice question for a Monday ... great start to the week

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Evgeny Garaev

    SSCertifiable

    Points: 6323

    Author should emphasize that it will be one batch. It will be too many wrong answers.

  • Danny Ocean

    SSCertifiable

    Points: 6098

    I think author did mention it clearly that execute all statement in a single batch.

    Due to that i lose my points..:doze:

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

  • honza.mf

    SSCertifiable

    Points: 5519

    Evgeny (5/5/2013)


    Author should emphasize that it will be one batch. It will be too many wrong answers.

    The question states the batch in the very beggining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.



    See, understand, learn, try, use efficient
    © Dr.Plch

  • kapil_kk

    SSC-Insane

    Points: 21316

    Danny Ocean (5/5/2013)


    I think author did mention it clearly that execute all statement in a single batch.

    Due to that i lose my points..:doze:

    Me too lose the points 🙁

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • PRAMANA.DBA

    SSCertifiable

    Points: 5507

    I didn't read question carefully...so lose the question.

  • Lokesh Vij

    SSChampion

    Points: 10836

    I too rushed (over read "batch") and got the question wrong! 🙁

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Lokesh Vij

    SSChampion

    Points: 10836

    kapil_kk (5/6/2013)


    Danny Ocean (5/5/2013)


    I think author did mention it clearly that execute all statement in a single batch.

    Due to that i lose my points..:doze:

    Me too lose the points 🙁

    +1 🙁

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Good one, thank you for the Kick Start Post. 🙂

    (well... long story short...) "damn!!!..." (where is my "learn sql in 21 hours for beginners" book?)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Mr. Kapsicum

    SSCertifiable

    Points: 6128

    Danny Ocean (5/5/2013)


    I think author did mention it clearly that execute all statement in a single batch.

    Due to that i lose my points..:doze:

    Same goes for me as well.... just lost my valuable points 😎

  • Carlo Romagnano

    SSC-Insane

    Points: 21834

    The question states the batch in the very begining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.

    +1

    😀

    Good qotd, but too long, it worths 4 points.

  • honza.mf

    SSCertifiable

    Points: 5519

    Carlo Romagnano (5/6/2013)


    The question states the batch in the very begining, there are no batch separators, and answers contain "not run due to previous errors". I think it's enough.

    +1

    😀

    Good qotd, but too long, it worths 4 points.

    :hehe:

    Especially for the majority who answers before first coffee :w00t:



    See, understand, learn, try, use efficient
    © Dr.Plch

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

You must be logged in to reply to this topic. Login to reply