Stored Procedure

KiranS subramanian

11y1.1k

Have a store procedure which is encrypted when i execute that store procedure i get n number of columns from that i need to select only two columns and insert into separate table the 2 columns is product and oee

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Govinda Rajulu Yemineni11y ago
-- Create a temporary table according to the number of columns in the result set of the SP
CREATE TABLE #TempTable1(production_day VARCHAR(100),product VARCHAR(100),Actual_speed VARCHAR(50),Ideal_prod VARCHAR(50),.....,OEE VARCHAR(100))
GO

-- Insert the complete result set of the stored procedure in the table
INSERT INTO #TempTable1
EXEC StoredProcedureName
GO

-- create the table to which actually You want to push Data
CREATE TABLE #TempTable2(Product VARCHAR(100),OEE VARCHAR(100))
GO

-- Select the required columns from the temporary table.
INSERT INTO #TempTable2(Product,OEE)
SELECT Product,OEE FROM #TempTable1
GO

--Verify the Inserted records
SELECT * FROM #TempTable2
0
Sneha Sneha11y ago
Declare @ tabletemp table (product nvarchar(50), oee nvarchar(50));
insert into @tabletemp ( product, oee) exec nameofstored procedure;
Select * from @tabletemp;
0