DECLARE @TABELA TABLE (NUMERO INT)
DECLARE @CONT INT
SET @CONT = 0
WHILE @CONT <=100
BEGIN
INSERT INTO @TABELA VALUES (DBO.Numero_Aleatorio (100,999))
SET @CONT = @CONT + 1
END
SELECT DISTINCT * FROM @TABELA
Solucionado
DECLARE @TABELA TABLE (NUMERO INT)
DECLARE @CONT INT
SET @CONT = 0
WHILE @CONT <=100
BEGIN
INSERT INTO @TABELA VALUES (DBO.Numero_Aleatorio (100,999))
SET @CONT = @CONT + 1
END
SELECT DISTINCT * FROM @TABELA
