Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sanjay Kumar Display data by fiscal year instead of calendar year RE: Display data by fiscal year instead of calendar year

  • August 7, 2012 at 7:34 am

    #1522591

    CELKO (8/7/2012)

    Why not use a Calendar table with whatever fiscal or reporting years you use? The GAAP had 250+ the last time I looked. SQL is not a computional language and function calls only prevent optimization.

    I have to agree with Mr Celko.

    My first thought to the solution to this was a Calendar Table with a column for Fiscal Year and a column for Calendar year. Then you don't have to do anything complicated.


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]