troubleshooting Question

SQL for Month over Month change

Avatar of saved4use
saved4useFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2008SQL
4 Comments1 Solution1222 ViewsLast Modified:
I need to calculate month over month changes and express those a percentage.
How can I modify my T-SQL code below to accomplish that? Thanks.

SELECT
Current_MO - Last_MO as MOM_Change

FROM(SELECT
count(distinct a.TRADE_ERROR_ID) as Current_MO


FROM
rpt.V_SHAREPOINT_TRADE_ERRORS a


WHERE
TRADE_DT >= dateadd(month, datediff(month, 0, getdate()) - 1, 0)
AND TRADE_DT < dateadd(month, datediff(month, 0, getdate()), 0)
and a.REP_RESPONSIBLE is not null

UNION ALL

SELECT
count(distinct b.TRADE_ERROR_ID) as Last_MO


FROM
rpt.V_SHAREPOINT_TRADE_ERRORS b
--Inner join


WHERE
b.TRADE_DT >= dateadd(month, datediff(month, 1, getdate()) - 1, 0)
AND b.TRADE_DT < dateadd(month, datediff(month, -1, getdate()), 0)
and b.REP_RESPONSIBLE is not null) as c
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros