You'll have to create temp table with structure that matches SP's result set first. For example, assuming that 'GenRand' SP returns integer,

CREATE TABLE #temp1 ( RandPass int  )
INSERT INTO #temp1 
	EXECUTE ('GenRand')
SELECT RandPass 
	FROM #temp1
DROP TABLE #temp1

>I would like to populate a password field in a table with a randomly generated password. I have a sp that generates the password, but cannot figure out how to use it in an INSERT statement. I tried to create a UDF but cannot use RAND() in it.
>
>TIA
>
>John