SQL for Weighted Survey Results
SELECTÂ Â Â Â Â TOP 100 PERCENT dbo.tblESSurveyW1Demo.CQ30, SUM(dbo.tblESSurveyW1Weight.weight_bb) AS WeightedCount, Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â COUNT(dbo.tblESSurveyW1Weight.RESPID) AS UnWeighted FROMÂ Â Â Â Â Â Â Â Â dbo.tblESSurveyW1Weight INNER JOIN Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â dbo.tblESSurveyW1Demo ON dbo.tblESSurveyW1Weight.RESPID = dbo.tblESSurveyW1Demo.RESPID GROUP BY dbo.tblESSurveyW1Demo.CQ30 ORDER BY dbo.tblESSurveyW1Demo.CQ30
