NEED THIS ACCESS QUERY FOR SQL ..LET ME KNOW WHAT CHANGES TO BE MADE.....
SELECT SUM(IIf([SYR_CTR_START_MONTH]=1, SYR_SUM_AMZ_INV_AMT, 0)) AS JAN,
SUM(IIf([SYR_CTR_START_MONTH]=2, SYR_SUM_AMZ_INV_AMT, 0)) AS FEB,
SUM(IIf([SYR_CTR_START_MONTH]=3, SYR_SUM_AMZ_INV_AMT, 0)) AS MAR,
SUM(IIF([SYR_CTR_START_MONTH] = 4 ,SYR_SUM_AMZ_INV_AMT ,0)) AS APR ,
SUM( IIF ([SYR_CTR_START_MONTH] = 5 ,SYR_SUM_AMZ_INV_AMT ,0)) AS MAY ,
SUM( IIF ([SYR_CTR_START_MONTH] = 6 ,SYR_SUM_AMZ_INV_AMT ,0)) AS JUN ,
SUM( IIF ([SYR_CTR_START_MONTH] = 7 ,SYR_SUM_AMZ_INV_AMT ,0)) AS JUL ,
SUM( IIF ([SYR_CTR_START_MONTH] = 8 ,SYR_SUM_AMZ_INV_AMT ,0)) AS AUG ,
SUM( IIF ([SYR_CTR_START_MONTH] = 9 ,SYR_SUM_AMZ_INV_AMT ,0)) AS SEP ,
SUM( IIF ([SYR_CTR_START_MONTH] = 10 ,SYR_SUM_AMZ_INV_AMT ,0)) AS OCT ,
SUM( IIF ([SYR_CTR_START_MONTH] = 11 ,SYR_SUM_AMZ_INV_AMT ,0)) AS NOV ,
SUM( IIF ([SYR_CTR_START_MONTH] = 12 ,SYR_SUM_AMZ_INV_AMT ,0)) AS DEC ,
SUM(IIf([SYR_CTR_START_MONTH]<=3, SYR_SUM_AMZ_INV_AMT, 0)) AS Q1,
SUM(IIf([SYR_CTR_START_MONTH]>=4 AND [SYR_CTR_START_MONTH]<=6, SYR_SUM_AMZ_INV_AMT, 0)) AS Q2,
SUM(IIf([SYR_CTR_START_MONTH]>=7 AND [SYR_CTR_START_MONTH]<=9, SYR_SUM_AMZ_INV_AMT, 0)) AS Q3,
SUM(IIf([SYR_CTR_START_MONTH]>=10 AND [SYR_CTR_START_MONTH]<=12, SYR_SUM_AMZ_INV_AMT, 0)) AS Q4,
SUM(SYR_SUM_AMZ_INV_AMT) AS FY
FROM NTLRESULTS_AZ_SMY_YPC_RPT_TBL
WHERE SYR_UPD_USER='EXCEPTION2';
SELECT SUM(IIf([SYR_CTR_START_MONTH]=1, SYR_SUM_AMZ_INV_AMT, 0)) AS JAN,
SUM(IIf([SYR_CTR_START_MONTH]=2, SYR_SUM_AMZ_INV_AMT, 0)) AS FEB,
SUM(IIf([SYR_CTR_START_MONTH]=3, SYR_SUM_AMZ_INV_AMT, 0)) AS MAR,
SUM(IIF([SYR_CTR_START_MONTH] = 4 ,SYR_SUM_AMZ_INV_AMT ,0)) AS APR ,
SUM( IIF ([SYR_CTR_START_MONTH] = 5 ,SYR_SUM_AMZ_INV_AMT ,0)) AS MAY ,
SUM( IIF ([SYR_CTR_START_MONTH] = 6 ,SYR_SUM_AMZ_INV_AMT ,0)) AS JUN ,
SUM( IIF ([SYR_CTR_START_MONTH] = 7 ,SYR_SUM_AMZ_INV_AMT ,0)) AS JUL ,
SUM( IIF ([SYR_CTR_START_MONTH] = 8 ,SYR_SUM_AMZ_INV_AMT ,0)) AS AUG ,
SUM( IIF ([SYR_CTR_START_MONTH] = 9 ,SYR_SUM_AMZ_INV_AMT ,0)) AS SEP ,
SUM( IIF ([SYR_CTR_START_MONTH] = 10 ,SYR_SUM_AMZ_INV_AMT ,0)) AS OCT ,
SUM( IIF ([SYR_CTR_START_MONTH] = 11 ,SYR_SUM_AMZ_INV_AMT ,0)) AS NOV ,
SUM( IIF ([SYR_CTR_START_MONTH] = 12 ,SYR_SUM_AMZ_INV_AMT ,0)) AS DEC ,
SUM(IIf([SYR_CTR_START_MONTH]<=3, SYR_SUM_AMZ_INV_AMT, 0)) AS Q1,
SUM(IIf([SYR_CTR_START_MONTH]>=4 AND [SYR_CTR_START_MONTH]<=6, SYR_SUM_AMZ_INV_AMT, 0)) AS Q2,
SUM(IIf([SYR_CTR_START_MONTH]>=7 AND [SYR_CTR_START_MONTH]<=9, SYR_SUM_AMZ_INV_AMT, 0)) AS Q3,
SUM(IIf([SYR_CTR_START_MONTH]>=10 AND [SYR_CTR_START_MONTH]<=12, SYR_SUM_AMZ_INV_AMT, 0)) AS Q4,
SUM(SYR_SUM_AMZ_INV_AMT) AS FY
FROM NTLRESULTS_AZ_SMY_YPC_RPT_TBL
WHERE SYR_UPD_USER='EXCEPTION2';