I am trying to store the result of my read/write stored procedure in local temporary table. After creating the temp table i am writing -
INSERT INTO #TMP call SPName;
to store the result in temp table but it says feature not supported. Is there anyway to store the result of stored procedure in temp table. I don't want to alter the definition of already build SP but want to store the result in temp table to join with another set of statement to get my final result.