Forum Replies Created

Viewing 15 posts - 151 through 165 (of 541 total)

  • RE: Running total error

    ChrisM@Work (6/25/2014)

    pwalter83 (6/25/2014)

    ChrisM@Work (6/25/2014)

    pwalter83 (6/25/2014)

    ChrisM@Work (6/25/2014)

    pwalter83 (6/24/2014)

    ChrisM@Work (6/24/2014)

    pwalter83 (6/24/2014)

    Jeff Moden (6/24/2014)

    pwalter83 (6/24/2014)

    ChrisM@Work (6/24/2014)

    Here's a quick rejig of that sample data, and a reformat of the code. Is it only the...

    June 25, 2014 at 3:48 am

    #1724547

  • RE: Running total error

    ChrisM@Work (6/25/2014)

    pwalter83 (6/25/2014)

    ChrisM@Work (6/25/2014)

    pwalter83 (6/24/2014)

    ChrisM@Work (6/24/2014)

    pwalter83 (6/24/2014)

    Jeff Moden (6/24/2014)

    pwalter83 (6/24/2014)

    ChrisM@Work (6/24/2014)

    Here's a quick rejig of that sample data, and a reformat of the code. Is it only the running total...

    June 25, 2014 at 3:32 am

    #1724543

  • RE: Running total error

    ChrisM@Work (6/25/2014)

    pwalter83 (6/24/2014)

    ChrisM@Work (6/24/2014)

    pwalter83 (6/24/2014)

    Jeff Moden (6/24/2014)

    pwalter83 (6/24/2014)

    ChrisM@Work (6/24/2014)

    Here's a quick rejig of that sample data, and a reformat of the code. Is it only the running total column which...

    June 25, 2014 at 2:24 am

    #1724536

  • RE: Running total error

    ChrisM@Work (6/24/2014)

    pwalter83 (6/24/2014)

    Jeff Moden (6/24/2014)

    pwalter83 (6/24/2014)

    ChrisM@Work (6/24/2014)

    Here's a quick rejig of that sample data, and a reformat of the code. Is it only the running total column which is incorrect?

    IF...

    June 24, 2014 at 9:39 am

    #1724381

  • RE: Running total error

    Jeff Moden (6/24/2014)

    pwalter83 (6/24/2014)

    ChrisM@Work (6/24/2014)

    Here's a quick rejig of that sample data, and a reformat of the code. Is it only the running total column which is incorrect?

    IF OBJECT_ID ('tempdb..#GLT')...

    June 24, 2014 at 8:49 am

    #1724364

  • RE: Running total error

    ChrisM@Work (6/24/2014)

    Here's a quick rejig of that sample data, and a reformat of the code. Is it only the running total column which is incorrect?

    IF OBJECT_ID ('tempdb..#GLT') IS NOT NULL...

    June 24, 2014 at 7:37 am

    #1724325

  • RE: Running total error

    Lynn Pettis (6/23/2014)

    Jeff Moden (6/23/2014)

    pwalter83 (6/23/2014)

    ChrisM@Work (6/23/2014)

    pwalter83 (6/23/2014)

    ChrisM@Work (6/23/2014)

    Paul, you have two threads open which cover the same problem. Can I suggest you choose one of them and close the...

    June 24, 2014 at 3:37 am

    #1724261

  • RE: Running total error

    ChrisM@Work (6/23/2014)

    pwalter83 (6/23/2014)

    ChrisM@Work (6/23/2014)

    Paul, you have two threads open which cover the same problem. Can I suggest you choose one of them and close the other? You can do that...

    June 23, 2014 at 7:27 am

    #1724070

  • RE: Running total error

    ChrisM@Work (6/23/2014)

    Paul, you have two threads open which cover the same problem. Can I suggest you choose one of them and close the other? You can do that by posting...

    June 23, 2014 at 5:01 am

    #1724006

  • RE: Running total in sql and additional issue

    No further posts to this thread, please see the new link:

    http://www.sqlservercentral.com/Forums/Topic1584256-391-4.aspx

    June 23, 2014 at 4:48 am

    #1724003

  • RE: Running total error

    Sachin Nandanwar (6/20/2014)

    pwalter83 (6/20/2014)

    Sachin Nandanwar (6/20/2014)

    I dont understand the problem here.Your query seems to be achieving it.

    CREATE TABLE [dbo].[GL](

    [Sequence] [int] NOT NULL,

    [WK NO] [int] NULL,

    [AC] [nvarchar](10) NULL,

    [COMP] [nvarchar](10) NULL,

    [USD_AMOUNT]...

    June 23, 2014 at 4:18 am

    #1723988

  • RE: Running total error

    ChrisM@Work (6/23/2014)

    pwalter83 (6/23/2014)

    ChrisM@Work (6/23/2014)

    pwalter83 (6/23/2014)

    ... I need to use the following query to get the desired resultset. I think that is where the problem is

    If the query you "need to...

    June 23, 2014 at 3:45 am

    #1723965

  • RE: Running total error

    mister.magoo (6/23/2014)

    mister.magoo (6/20/2014)

    Can I ask what is not working in the SSRS RunningTotal, it may just be a scope problem?

    Evil Kraig F (6/20/2014)

    pwalter83 (6/20/2014)

    I am trying to calculate running total...

    June 23, 2014 at 3:40 am

    #1723963

  • RE: Running total error

    ChrisM@Work (6/23/2014)

    pwalter83 (6/23/2014)

    ... I need to use the following query to get the desired resultset. I think that is where the problem is

    If the query you "need to use" doesn't...

    June 23, 2014 at 3:04 am

    #1723941

  • RE: Running total error

    Sachin Nandanwar (6/20/2014)

    pwalter83 (6/20/2014)

    Sachin Nandanwar (6/20/2014)

    I dont understand the problem here.Your query seems to be achieving it.

    CREATE TABLE [dbo].[GL](

    [Sequence] [int] NOT NULL,

    [WK NO] [int] NULL,

    [AC] [nvarchar](10) NULL,

    [COMP] [nvarchar](10) NULL,

    [USD_AMOUNT]...

    June 23, 2014 at 2:18 am

    #1723918

Viewing 15 posts - 151 through 165 (of 541 total)