Hi,

When i execute the stored procedure(Exec statement below) i get the output, but when i store the values to a table variable the data is not stored in table variable.

Code:
DECLARE @SLA_STATUS TABLE (request_id BIGINT,sla_status VARCHAR(200))
INSERT INTO @SLA_STATUS
EXEC [SCHEMACOGPTG].[PR_SMGT_GET_SLA_FOR_AMReport] '183732,9625312,9625340,10062931,10062933,10062946,10062947,10062948,10062949,10062950,10062962,10062969,10062970,10062971,10063019,10063029,10063056'
select * from @SLA_STATUS