Declare @tablecount int
Set @tablecount = (Select count (*) from #TEMPCUST)
CREATE TABLE #TEMPCOUNT (RECORD int)
INSERT INTO #TEMPCOUNT
EXEC sp_Gen_Random_Numbers 1,@tablecount,10000
You need to make sure your temp table columns are of a data type that the Exec will return and that the Exec return is in the order of the columns in your temp table.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.