Skip to content

Instantly share code, notes, and snippets.

@bluejaysql

bluejaysql/Applied floor() example

Created October 9, 2015 06:16
Show Gist options
  • Save bluejaysql/2ea5abbb944746ac3424 to your computer and use it in GitHub Desktop.
Save bluejaysql/2ea5abbb944746ac3424 to your computer and use it in GitHub Desktop.
Download ZIP
sqlfloorfunction-2.sql
Raw
Applied floor() example
declare @dropdownselection as decimal
set @dropdownselection = 8.0
select q.QID
from Questions as q
where floor(q.ObjNum) = @dropdownselection
order by q.QID;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment