Skip to content

Instantly share code, notes, and snippets.

@hotgazpacho

hotgazpacho/gist:1246356

Created September 27, 2011 21:52
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save hotgazpacho/1246356 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save hotgazpacho/1246356 to your computer and use it in GitHub Desktop.
Download ZIP
How do I write this as a QueryOver.Of<ExamResult>()
Raw
gistfile1.sql
SELECT ~CAST((Count(ResultId) - SUM(CAST(SatisfiesPeriodicRequirement as INT))) as bit)
FROM ExamResults
WHERE SurveillanceId = 7927
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment