STORED PROCEDURE

Question

hi 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

Upendra Pratap Shahi · Answer

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

Prasad Bhagat · Answer

CREATE PROCEDURE USP_ABC AS BEIGN SELECT ID NAME SALARY FROM tbl_employee order by id desc end

Pankaj Kumar Choudhary · Answer

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

Saroj Kumar Sahu · Answer

Hi KiranS Please go through the below link. http://blog.sqlauthority.com/2013/09/26/sql-server-select-columns-from-stored-procedure-resultset/

Khrizz · Answer

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

Manish Dwivedi · Answer

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

KiranS subramanian · Answer

HI MANOJ I WANT TO RETRIVE VALUES FROM STORE PROCEDURE NOT FROM TABLE

Manoj Bhoir · Answer

Hi Just Create new procedure : CREATE PROCEDURE ProcedureName AS BEGIN SELECT Column1 Column2 From TableName END GO

Upendra Pratap Shahi · Answer

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_nameemp_add from employee where emp_id='DL000001 I think it may help you if help kindly accept the answer .

KiranS subramanian · Answer

please tell me what is column 3