My store procedure returns / select 3 tables after execution.
How can I insert only 1st table in table variable in SQL?
The below code is I am using
- declare @myTable as table
- (
- A_Name nvarchar(128),
- A_Id nvarchar(128),
- A_Total varchar(128)
- --- more columns
- )
-
- INSERT INTO @myTable
- EXEC 'sp_helpdb' 'Param1'
Thanks in advance