临时表 调用另一个存储过程

DECLARE @Number VARCHAR(30)
 CREATE TABLE #table(Number VARCHAR(30))

INSERT INTO #table EXEC Get_Sys_Series_Number 'SCK','ShopCheckOrd','CkOrdNum',3,@Sp_Id
    SELECT * FROM #table
    DROP TABLE #table