mesutd0nmez
7/29/2017 - 7:48 AM

Creating temp table that hold the proc result and can select spesific column

Creating temp table that hold the proc result and can select spesific column

temptable.sql
content_copyfile_download
CREATE TABLE #Result
(
  ID int,  Name varchar(500), Revenue money
)
INSERT #Result EXEC RevenueByAdvertiser '1/1/10', '2/1/10'
SELECT * FROM #Result ORDER BY Name
DROP TABLE #Result