select top '+cast(@recordcount as varchar)+' CustomerID
		into T..random_'+@tablename+'		
		from (
		select distinct CustomerID
		from #'+@tablename+'
		) s

DROP PROCEDURE uspRandomize
GO

CREATE PROCEDURE uspRandomize
@tablename AS NVARCHAR(25),
@recordcount AS INT = 0
AS

	SET NOCOUNT ON		

	DECLARE @message AS NVARCHAR(500)

	IF @tablename = '' 
	BEGIN
		SET @message = 'You did not enter a table name'
		SELECT @message
		RETURN 1
	END
	ELSE

	IF @recordcount < 1
	BEGIN
		SET @message = 'You did not enter a record count'
		SELECT @message
		RETURN 1
	END
	ELSE

	BEGIN

		declare @sql as nvarchar(4000)

		-- Random table holding desired count
		set @sql = '		
		if object_id(N''T..random_'+@tablename+''') is not null
		begin
		drop table T..random_'+@tablename+'
		end
		'
		exec sp_executesql @sql

		-- Insert number of desired records
		set @sql = '
		select top '+cast(@recordcount as varchar)+' CustomerID
		into T..random_'+@tablename+'		
		from (
		select distinct CustomerID
		from '+@tablename+'
		) s
		order by newid()	-- a large recordset it will have a severe performance impact
		'
		exec sp_executesql @sql

		-- Return result set containing the selected records
		set @sql = '
		SELECT Count(CustomerID) AS "Random Count"
		FROM T..random_'+@tablename
		exec sp_executesql @sql
	
		-- Check for duplicates
		set @sql = '
		SELECT CustomerID AS "Duplicates"
		FROM T..random_'+@tablename+'
		GROUP BY CustomerID
		HAVING COUNT(CustomerID) > 1
		'
		exec sp_executesql @sql

	END

GO

--Usage
exec uspRandomize @tablename = <name of table>, @recordcount = <choose amount>