how-to store the output of a stored procedure into a temporary table on sql server

use master ;

declare @HostNameAndInstance nvarchar(30)
set @HostNameAndInstance = 'hostName\POC_QA'

exec sp_configure 'Show Advanced Options', 1
GO
RECONFIGURE
GO
exec sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
--Drop the table if it exists
IF OBJECT_ID('tempdb.dbo.#UsersList') IS NOT NULL
DROP TABLE #UsersList

SELECT * INTO #UsersList
FROM OPENROWSET('SQLNCLI', 'server=hostName\POC_QA;trusted_connection=yes;Initial Catalog=CAS;',
'set fmtonly off exec sp_helplog')

select UserName , RoleName , LoginName , DefDBName , DefSchemaName from #UsersList