CREATE TABLE #mytable (
	UserName sysname, 
	GroupName sysname,
	LoginName sysname Null,
	DefDBName sysname Null,
	UserID smallint,
	SID smallint )


INSERT #mytable EXEC sp_helpuser 
SELECT * FROM #mytable

>Hello All.
>I’d like to use the result set returned by one (called) procedure within another (calling) procedure. Something like this:
>
>SELECT * FROM (EXEC(sp_helpuser)) INTO TABLE #MyTable
>
>Thank you.
>Kamil.