Skip to content

Instantly share code, notes, and snippets.

@ejhayes

ejhayes/max_number.sql

Created July 15, 2010 23:11
Show Gist options
  • Save ejhayes/477679 to your computer and use it in GitHub Desktop.
Save ejhayes/477679 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
max_number.sql
SELECT @R_RECORD_NO = max(r_record_no) + 1
FROM ats.r_record r
WHERE fy_id = @L_FY_ID
AND asub_id in (select asub_id from ats.asub_acquisition_subtype asub1 where asub_char = (select asub_char from ats.asub_acquisition_subtype where asub_id = @L_ASUB_ID))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment