hello,
I am using this SP, it should have alpha numeric for each record it's generate but many times it does not generates alpha numeric all the time.
CREATE PROCEDURE [dbo].[Random_Number_Generator]
@maxNumbers INT
AS
BEGIN
BEGIN TRY
DROP TABLE #rand_numbers
END TRY
BEGIN CATCH
PRINT '##rand_numbers not available to drop'
END CATCH
CREATE TABLE #rand_numbers
(
rand_number VARCHAR(6)
)
DECLARE @loop_ctr INT = 0
WHILE @loop_ctr < 5
BEGIN
DECLARE @NewId VARCHAR(255)
SELECT @NewId = NEWID()
SELECT CAST((ABS(CHECKSUM(@NewId))%10) AS VARCHAR(1)) +
CHAR(ASCII('A')+(ABS(CHECKSUM(@NewId))%25)) + LEFT(@NewId,4)
END
END
I want to keep it in a loop so i pass 100 it should generate 100 rows alpha numeric.
kindly advice.
