Post reply

Logic

  • December 22, 2010 at 3:39 pm

    #229878

    I am struck with logics can any one guide me

    i am having a table called score card it has 2 columns one is balls and other one is runs

    balls Runs

    12

    22

    34

    46

    56

    66

    i need to get at what ball the sum of runs got 10

  • December 22, 2010 at 4:36 pm

    #1265742

    sounds like homework...

    There are three choices:

    a triangular self join,

    a recursive CTE, or

    a "quirky update" approach.

    If it's homework, go for the first. If it's performance critical and there are people around knowing what they do, go for quirky update. Otherwise, use recursive CTE. 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • December 23, 2010 at 12:58 pm

    #1266046

    This is a interview question in a company named kadambha technologies

  • December 23, 2010 at 1:09 pm

    #1266049

    If it's an interview question, try to answer it by yourself and do some research on it.

    Post your answer and see what others think about it.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 4 posts - 1 through 4 (of 4 total)

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