Skip to content

Instantly share code, notes, and snippets.

@stphnwlkr

stphnwlkr/MaxRows

Last active April 11, 2016 16:14
Show Gist options
  • Save stphnwlkr/b7a0fc12b12930a08ee3 to your computer and use it in GitHub Desktop.
Save stphnwlkr/b7a0fc12b12930a08ee3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MaxRows
query function getSpecialtyCodeChartData(required numeric rc=99){
var sc = queryExecute("Select specialtyname, qty From specialtycategorycount_view
Order by qty DESC, specialtyname",{},{maxrows = "#rc#"});
return sc;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment