How to write a query to compare Current year fiscal period sales to Last year Fiscal Period sales in SQL Server

(0) Share

Report

Posted on by Community Member

I am trying to write a query in SQL server that pulls data from multiple tables and stores it into a new table and I only want the data that compares current year Fiscal period to Last year Fiscal period.

Any help is greatly appreciated.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

P.S : I already have a table that has fiscal period and year defined so I can just join that table. To be specific, I want to write a query that only gives data for last year fiscal period based on current year fiscal period.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

You can follow these examples plus use the SQL DateDiff function to separate current and last fiscal years.

stackoverflow.com/.../how-to-do-a-sum-inside-a-case-statement-in-sql-server

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi NP41,

Maybe it would be much simpler to just use Management Reporter 2012 to do that work ? it has built-in functions to pull data based on Fiscal periods, so you could compare current period with LY period at the same time, and even add the Budget for that period..

Was this reply helpful? Yes No