Forum Replies Created

Viewing 15 posts - 571 through 585 (of 2,452 total)

  • RE: UNION with CASE statement

    Newbi (6/30/2016)


    You can't have make custom page without SQL when you have more than one group. Cannot use row limit or whatsoever, as far as I have researched. Easily can...

  • RE: UNION with CASE statement

    Newbi (6/30/2016)


    I don't know how to display well enough here according to the guidelines of the forum. :crying:

    try this article for future reference:

    https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

    however in this case it may not be...

  • RE: UNION with CASE statement

    twin.devil (6/30/2016)


    Newbi (6/30/2016)


    Because SSRS designing alone cannot fulfill my requirements.

    Shed some light on it.

    and please post some sample data so that we can all work on the same data set...

  • RE: Need algorithm for Complex looping logic

    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 using a while...

  • RE: Improvements in SQL Server Environment

    chased for Service Improvements

    chased by whom?

    what are they asking for?

  • RE: Need algorithm for Complex looping logic

    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......?

  • RE: UNION with CASE statement

    maybe.....??

    USE [tempdb]

    GO

    CREATE TABLE [dbo].[Data_Details](

    [ICode] [int] NULL,

    [Quantity] [int] NULL

    )

    GO

    INSERT [dbo].[Data_Details] ([ICode], [Quantity]) VALUES (1, 23)

    INSERT [dbo].[Data_Details] ([ICode], [Quantity]) VALUES (1, -15)

    INSERT [dbo].[Data_Details] ([ICode], [Quantity]) VALUES (1, 17)

    INSERT [dbo].[Data_Details] ([ICode], [Quantity])...

  • RE: Need algorithm for Complex looping logic

    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 around this site....read...

  • RE: Need algorithm for Complex looping logic

    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 TT as (

    SELECT...

  • RE: Need algorithm for Complex looping logic

    JoNTSQLSrv (6/27/2016)


    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...

  • RE: Need algorithm for Complex looping logic

    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 real world table...

  • RE: Date Range overlaps

    Jeff Moden (6/27/2016)


    Nomvula (6/27/2016)


    thank you so much J Livingston SQL,

    it worked perfectly!!!

    Since you're the one that needs to support it, the question now is... can you? Do you actually...

  • RE: Need algorithm for Complex looping logic

    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 the results be?...

  • RE: Need algorithm for Complex looping logic

    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 an error? If...

  • RE: Need algorithm for Complex looping logic

    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 perfect data .....

Viewing 15 posts - 571 through 585 (of 2,452 total)