DECLARE @TempTable Table(field1 varchar(max),field2 varchar(max), field3 varchar(max) INSERT @TempTable= EXECUTE dbo.sp_MySP @SomeParam --Issue is this gives xml rather than a table SELECT * FROM @TempTable
=
INSERT @TempTable EXECUTE dbo.sp_MySP @SomeParam
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)