Post reply

While loop 2

  • October 11, 2012 at 8:15 pm

    #265619

    Comments posted to this topic are about the item While loop 2

  • October 11, 2012 at 8:16 pm

    #1548418

    Thanks for a good question - good thing I had my coffee before answering

    Again thanks

    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]

  • October 11, 2012 at 10:10 pm

    #1548433

    Thanks Sreenivas for the question. Indeed we discussed the situation of "Divide by zero error" in your earlier QOTD discussion forum "While Loop - 1".

    All in all ending this week on a good note 🙂

    ~ 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

  • October 11, 2012 at 10:31 pm

    #1548437

    Good Morning Sreeni.. Thanx for the easy Point..

  • October 11, 2012 at 10:41 pm

    #1548438

    Thanks for good question. Error is because of data type. SQLserver implicitly convert float into integer for @b-2 variable. Hence divide by zero error encountered.

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)

  • October 12, 2012 at 12:18 am

    #1548452

    I am newbie..

    can anyone explain me why divide by zero error encountered...

    as 10/.001 is thr

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

  • October 12, 2012 at 12:31 am

    #1548454

    Oopes I am clear with answer now..

    I confused with the byte size of int and float so select wrong answer... 🙁 🙁

    as .001 will will gets converted into 0 so when counter moves to 4 it will show error 'divide by zero encountered'

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

  • October 12, 2012 at 1:48 am

    #1548474

    Easy points in a row, fine. 🙂

  • October 12, 2012 at 2:10 am

    #1548478

    Good question, thank you. Had to read twice to make sure I wasn't missing a 'trick'!

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.

  • October 12, 2012 at 2:33 am

    #1548489

    Nice question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 12, 2012 at 2:53 am

    #1548501

    Lokesh Vij (10/11/2012)

    Thanks Sreenivas for the question. Indeed we discussed the situation of "Divide by zero error" in your earlier QOTD discussion forum "While Loop - 1".

    All in all ending this week on a good note 🙂

    And I didn't have to rethink for this one..;-):w00t::hehe:

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

  • October 12, 2012 at 3:02 am

    #1548503

    Damn it. Answered the question fast. Did not see the variable @b-2 is int.

  • October 12, 2012 at 3:10 am

    #1548508

    Easy one to end the week. Thanks Sree 🙂

    Sujeet Singh

  • October 12, 2012 at 3:19 am

    #1548510

    Darn! Saw the question, and for a few various reasons I thought it was the same question as the last time, and presumed a mistake with SSC or caching or something, so answered same as last time and Doh! Wrong!

    That'll teach me not to pay attention :doze:

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • October 12, 2012 at 5:05 am

    #1548553

    Thanks for the easy question to end the week on a high note!

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

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