Forum Replies Created

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

  • RE: Fiscal Year Case Statement?

    Guru, we ended up using the PS_INSTALLATION TBL for our reference for GETDATE ()) as it will always stay the same. 

     SELECT A.FISCAL_YEAR, A.ACCOUNTING_PERIOD, A.DEPTID, A.ACCOUNT, SUM(...

    May 10, 2018 at 8:49 am

    #1990056

  • RE: SQL Error

    Lynn Pettis - Wednesday, March 14, 2018 10:08 AM

    justin.randolph - Wednesday, March 14, 2018 10:02 AM

    March 14, 2018 at 10:13 am

    #1983212

  • RE: SQL Error

    Lynn Pettis - Wednesday, March 14, 2018 9:08 AM

    I found an extraneous ( where a MAX function is being called.  After deleting...

    March 14, 2018 at 10:02 am

    #1983206

  • RE: SQL Error

    HanShi - Wednesday, March 14, 2018 8:35 AM

    In the code posted in my previous post it is just the letter "x".

    March 14, 2018 at 9:02 am

    #1983182

  • RE: SQL Error

    HanShi - Wednesday, March 14, 2018 8:01 AM

    You must give a name or alias to the sub select part.
    I you enter a...

    March 14, 2018 at 8:10 am

    #1983158

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