Skip to content

Instantly share code, notes, and snippets.

@ivanionut

ivanionut/MaxRows

Forked from stphnwlkr/MaxRows
Created April 11, 2016 16:14
Show Gist options
  • Save ivanionut/2eac205801717362dc37fdb3cb838943 to your computer and use it in GitHub Desktop.
Save ivanionut/2eac205801717362dc37fdb3cb838943 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