STORED PROCEDURE

KiranS subramanian

11y1.4k

I 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 TWO columns ARE product and oee

10 Replies

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

Prasad Bhagat11y ago
CREATE PROCEDURE USP_ABC
AS
BEIGN
SELECT
ID,
NAME,
SALARY
FROM
tbl_employee
order by id desc
end
0
Pankaj Kumar Choudhary11y ago
hello Kirans you can use these three steps

Step 1:
Create Proc My_Pro
as begin
select * from Employee
end
// Use here your Stored Procedure

Step 2:
CREATE TABLE #TempTable (Col1 INT, Col2 INT)
GO
INSERT INTO #TempTable
EXEC My_Pro

Step 3:
SELECT *
FROM #TempTable
0
Saroj Kumar Sahu11y ago
Hi KiranS,
Please go through the below link.
http://blog.sqlauthority.com/2013/09/26/sql-server-select-columns-from-stored-procedure-resultset/
0
Khrizz11y ago
HI KiranS
You have to first create temp table or declare table variable that is similar to your stored proc. Then insert the output of your stored proc like this:

Insert Into @tempTableLikeStoredProc
Exec YourStoredProc

Then use the data in temp table to insert in your tables where you need the data.. something like this:
Insert Into TableProduct
( Product
)
Select Product From @tempTableLikeStored

Insert Into TableOOE (
OEE
)
Select OEE From @tempTableLikeStored
0
Blocked Account11y ago
Hi Kiran,

You need to create one temp table then insert the output of SP to this table then select the required column from this temp table. Then drop the temp table.

CREATE TABLE #tmpData
(
Col1 INT,
col2 Int
)
INSERT INTO #tmpData
Exec SP_Name
select * from #tmpData
DROP TABLE #tmpData
0
KiranS subramanian11y ago
HI MANOJ

I WANT TO RETRIVE VALUES FROM STORE PROCEDURE NOT FROM TABLE
0
Manoj Bhoir11y ago
Hi,

Just Create new procedure :

CREATE PROCEDURE ProcedureName
AS
BEGIN
SELECT Column1, Column2 From TableName
END
GO
0
Upendra Pratap Shahi11y ago
Column3 is nothing it take just for example to check condition in WHERE clause.

like
select column1, column2 from your_table where colum3=@Input1

as

select emp_name,emp_add from employee where emp_id='DL000001"

I think it may help you, if help kindly accept the answer.
0
KiranS subramanian11y ago
please tell me what is column 3
0
Upendra Pratap Shahi11y ago
Hello,

Kindly write a SQL query inside the stored procedure with two columns which you have to want get.

like

Create Procedure Procedure-name
(
--Input parameters ,
--Output Parameters (If required)
@Input1 varchar(50)=''
)
As
Begin
--Sql statement used in the stored procedure
select column1, column2 from your_table where colum3=@Input1
End

create like this which return two column data
+1