question

Following is MS ACCESS query need to convert in Sql Server 2008R2 SELECT STAT_position.ReportDate AS [Position Date] ,First(smf.IssuerName) AS FirstOfIssuerName ,Sum(STAT_position.Units) AS SumOfUnits ,IIf(Sum(STAT_position.Units) = 0, 0, Sum((STAT_position.Units) * (smf.Coupon / 100)) / Sum(STAT_position.Units)) AS Coupon ,Sum(STAT_position.MarketValueGAAP) AS [SumOfPAM MV] ,First(smf.GLGroupName) AS FirstOfGLGroupName First(smf.NAICDesignation) AS FirstOfNAICDesignation FROM STAT_position ,smf WHERE STAT_position.SecurityID = smf.SecurityID GROUP BY STAT_position.ReportDate ,smf.RepDate ,STAT_position.Cusip ,STAT_position.Portfolio ,STAT_position.Basis HAVING ( ( (First(smf.GLGroupName)) <> "Futures (90)" AND (First(smf.GLGroupName)) <> "Options (95)") ) ORDER BY STAT_position.Cusip ,STAT_position.Portfolio;