• Skip to main content
  • Skip to header right navigation
  • Skip to site footer
Foster Solutions (FSI)

Foster Solutions (FSI)

The Solution is in the Process

  • Home
  • What We Do
  • Case Studies
    • Databases/Automation Case Studies
    • GIS/Market Research Case Studies
    • Local Government Case Studies
    • FSI – crosspollination – examples
  • Articles

SQL for Weighted Survey Results

July 8, 2008 by tech guys

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

Category: Stats/Software

Showcase Your Agency

Give your agency, business, or brand the sharp image it deserves with Mai Reach theme from BizBudding.

Buy Mai Reach Now

About tech guys

Previous Post:Pushpin online GIS technology
Next Post:Convert number to text with leading zero

Ready to get started?

Client Survey

Please take this survey if you are interested in a new or modified website. We will assess and get back with you as soon as possible.


Finding Solutions

We work with you to make things faster, easier and better.

  • Facebook
  • LinkedIn

Sites

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Features

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Support

  • Home
  • Blog
  • About
  • Features
  • Contact
  • Marketing

Copyright © 2025 · Foster Solutions (FSI) · All Rights Reserved

Back to top