Project Description
SELECT * INTO newTable
FROM (any sql script or any storedprocedure)

example:

use adventureworks
go
DECLARE @return_value int

EXEC @return_value = spExecScriptAndCreateTable
@executeSql='[dbo].[uspGetWhereUsedProductID] @StartProductID = NULL,@CheckDate = NULL',
@tableName='TesztForExec',@additionalFieldNames='x int,y int',
@additionalFieldValues='1,2',
@enums=1

select * from TesztForExec

Last edited Jun 16, 2008 at 3:58 PM by Safi, version 2