Forum Replies Created

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

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/30/2016)

    JoNTSQLSrv (6/30/2016)

    J Livingston SQL (6/29/2016)

    For knowledge shake, is it possible to implement the same result in while loop ?

    why?

    what benefits do you perceive you will gain by...

    June 30, 2016 at 3:57 am

    #1887805

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/29/2016)

    For knowledge shake, is it possible to implement the same result in while loop ?

    why?

    what benefits do you perceive you will gain by using a while loop......?

    Yes...

    June 30, 2016 at 1:51 am

    #1887790

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/28/2016)

    Please help me improving my sql thinking according to any bsiness requirement .. help me and suggest some books or sites .. thanks in advance

    suggest you stick...

    June 29, 2016 at 2:12 am

    #1887523

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/27/2016)

    you can try this......in all honesty I would be looking to review your tables and make recommendations so that the initial cte below is not required.

    that said....

    WITH...

    June 28, 2016 at 12:32 am

    #1887176

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/27/2016)

    I see in Credit_Mater table you have now added a second set of data for "Party" = 2......what is the significance of this please?

    Actually.... is this a...

    June 27, 2016 at 10:10 am

    #1887087

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/27/2016)

    JoNTSQLSrv (6/26/2016)

    J Livingston SQL (6/26/2016)

    JoNTSQLSrv (6/26/2016)

    GilaMonster (6/26/2016)

    JoNTSQLSrv (6/26/2016)

    it does nt work 🙁

    Be specific. What exactly is wrong? Wrong results? If so, where and what should...

    June 27, 2016 at 4:42 am

    #1886999

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/26/2016)

    JoNTSQLSrv (6/26/2016)

    GilaMonster (6/26/2016)

    JoNTSQLSrv (6/26/2016)

    it does nt work 🙁

    Be specific. What exactly is wrong? Wrong results? If so, where and what should the results be? Throws...

    June 26, 2016 at 1:33 pm

    #1886948

  • RE: Need algorithm for Complex looping logic

    GilaMonster (6/26/2016)

    JoNTSQLSrv (6/26/2016)

    it does nt work 🙁

    Be specific. What exactly is wrong? Wrong results? If so, where and what should the results be? Throws an error? If so,...

    June 26, 2016 at 12:22 pm

    #1886946

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/26/2016)

    JoNTSQLSrv (6/26/2016)

    sorry J Livingston SQL GURU,

    previously i put wrong data in urgent, please check now in the main post .. it is...

    June 26, 2016 at 11:51 am

    #1886944

  • RE: Need algorithm for Complex looping logic

    sorry J Livingston SQL GURU,

    previously i put wrong data in urgent, please check now in the main post .. it is perfect data .. please...

    June 26, 2016 at 10:11 am

    #1886941

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/25/2016)

    JoNTSQLSrv (6/25/2016)

    J Livingston SQL (6/25/2016)

    I am sorry...but I cannot tell you if its correct......you have to tell us.

    your sample dataset is small ...perhaps if you expand this...

    June 26, 2016 at 8:32 am

    #1886937

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/25/2016)

    I am sorry...but I cannot tell you if its correct......you have to tell us.

    your sample dataset is small ...perhaps if you expand this for more than one...

    June 25, 2016 at 1:21 pm

    #1886916

  • RE: Need algorithm for Complex looping logic

    @admin-2,

    I am extremely sorry for the duplicate reply post. It is my browser and net problem.

    June 25, 2016 at 12:18 pm

    #1886908

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/25/2016)

    JoNTSQLSrv (6/25/2016)

    J Livingston SQL (6/25/2016)

    maybe.....???

    WITH cte as (

    SELECT s.SellerID,

    MAX(c.Mincredit) AS mc

    FROM Seller_Table AS s

    LEFT OUTER...

    June 25, 2016 at 12:09 pm

    #1886907

  • RE: Need algorithm for Complex looping logic

    J Livingston SQL (6/25/2016)

    JoNTSQLSrv (6/25/2016)

    J Livingston SQL (6/25/2016)

    maybe.....???

    WITH cte as (

    SELECT s.SellerID,

    MAX(c.Mincredit) AS mc

    FROM Seller_Table AS s

    LEFT OUTER...

    June 25, 2016 at 12:04 pm

    #1886906

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