ststeiger/gist:662da186bf9543fee09d

Last active August 29, 2015 14:09

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ststeiger/662da186bf9543fee09d.js"></script>
Save ststeiger/662da186bf9543fee09d to your computer and use it in GitHub Desktop.

Download ZIP

Generate pseudo-random key-inventory-hook-number in Range 0-999 with 4 digits 0-padding

Raw

gistfile1.txt


	SELECT
	RIGHT('0000' + CAST(ABS(CHECKSUM(T_KeyGroup.KG_No + '.' + T_Key.Key_No)) % 1000 AS varchar(10)), 4) AS RPT_Hook

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment