Viewing 4 posts - 1 through 4 (of 4 total)
Thank you ScottPletcher. 🙂
June 5, 2018 at 3:17 pm
Random meaning just not in sequence. The format needed is #####-###### where the first 5 numbers is the community code and the next 6 random nonrepeating number is for the...
June 5, 2018 at 8:30 am
DECLARE @BrgyCode VARCHAR(5) = '23548';
SELECT
Ran.NextID,
Res.ResidentID,
@BrgyCode + '-'...
June 5, 2018 at 7:36 am
Does the SEQUENCE generates random numbers? Because what I need is a random number as a requirement. It should not be sequential thus I created/generated random non repeating numbers in...
June 5, 2018 at 7:35 am
Viewing 4 posts - 1 through 4 (of 4 total)