SELECT NEWID()
GO 50

SELECT NEWID()
FROM master..spt_values
WHERE name IS NULL
AND number < 50

SELECT TOP 50 NEWID() FROM master.dbo.sysobjects WHERE xtype = 'S'

--run these queries independently
CREATE TABLE #temp1 (ID UniqueIdentifier)
GO

INSERT INTO #temp1
SELECT NewID() AS ID
GO 50

SELECT *
FROM #temp1
GO

DROP TABLE #temp1
GO

-- Static solution: only 5 GUID values

SELECT  NEWID()
FROM    (VALUES(1), (2), (3), (4), (5)) AS Numbers(Number)

-- Dynamic solution

DECLARE @Num INT;
SET @Num=5;
SELECT  TOP(@Num)
        NEWID()
FROM    sys.objects o;

-- Another dynamic solution
--SET STATISTICS IO ON;
--GO

DECLARE @Num INT;
SET @Num=567;

WITH N10(Number)
AS (
    SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL
    SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9 UNION ALL SELECT 10
),  N100(Number)
AS (
    SELECT  (a.Number-1)*10+b.Number
    FROM    N10 AS a CROSS JOIN N10 AS b
),  N1000(Number)
AS (
    SELECT  (a.Number-1)*100+b.Number
    FROM    N100 AS a CROSS JOIN N100 AS b
)
SELECT  TOP(@Num)
        NEWID() AS [GUID]
FROM    N1000;