No announcements
Found 3423832 threads
-
4 Votesmerge the output of two stored procedures
Declare one table variable for Stored Procedure 1 2.Answered | 9 Replies | 23654 Views | Created by tsk238 - Thursday, August 26, 2010 1:50 PM | Last reply by swat3003 - Thursday, December 20, 2012 5:12 AM
-
0 Votes
How to get data from oracle stored procedure with two output (refCursor and varchar2) parameters
Hi, I have a oracle stored procedure with two output parameters refCursor and varchar2 so ...Answered | 1 Replies | 662 Views | Created by Kumar Jalli - Friday, August 21, 2015 1:32 PM | Last reply by DA924 - Friday, August 21, 2015 4:17 PM -
1 Votes
Stored procedure data output
As you already invested some efforts developing stored procedure it may be reasonable just to add logging functions into the procedure.Answered | 3 Replies | 1748 Views | Created by mynameismasel - Tuesday, December 18, 2012 7:44 AM | Last reply by SergNL - Tuesday, December 18, 2012 8:28 AM -
3 Votes
Stored Procedure Output parameter
Thank you, fixing my store procedure fixed it.Answered | 6 Replies | 3023 Views | Created by Nonabona - Tuesday, October 7, 2014 2:25 PM | Last reply by Nonabona - Tuesday, October 7, 2014 3:52 PM -
3 Votes
Store procedure truncates the output
I can see a stored procedure where you have defined @PopUpImage as nvarchar(max) but not shown the code/ table definition where that value is pulled ...Answered | 4 Replies | 4465 Views | Created by MHNDS - Sunday, April 15, 2012 1:56 AM | Last reply by Seth Lynch - Tuesday, April 17, 2012 9:02 AM -
0 Votes
How to output value from stored procedure
Hi brucey54, There’re several ways to capture the value from a Stored Procedure.Answered | 4 Replies | 1123 Views | Created by brucey54 - Wednesday, November 12, 2014 9:09 PM | Last reply by Eric_Zhang2 - Friday, November 14, 2014 3:14 AM -
0 Votes
Incorrect output from Stored Procedure
I assume you know how to get the result of your output parameter in PHP.Answered | 7 Replies | 8060 Views | Created by finchinator101 - Sunday, September 19, 2010 6:53 PM | Last reply by Robert Johnson - Monday, September 20, 2010 10:40 AM -
1 Votes
importance of OUTPUT in Stored procedure
BOL: -- Execute the procedure with a title_id value -- and save the output value and return code in variables.Answered | 3 Replies | 1426 Views | Created by chelseasadhu - Saturday, August 9, 2014 8:21 AM | Last reply by Kalman Toth - Saturday, August 9, 2014 3:40 PM -
0 Votes
capturing output from stored procedure
.* from msdb.dbo.sysjobs j inner join msdb.dbo.sysjobhistory h on j.job_id = h.job_id where j.name = 'yourJob' and h.run_date = '20111212'Answered | 6 Replies | 7870 Views | Created by sami09 - Monday, December 12, 2011 6:24 PM | Last reply by Naomi N - Monday, December 12, 2011 6:46 PM -
0 Votes
Execution of a Stored Procedure with No Output/Return values
You could create store procedure activity before the copy activity that you already setup, then chain these two activities via the dataset.Answered | 1 Replies | 683 Views | Created by Vijeth.Sankethi - Thursday, December 28, 2017 1:46 PM | Last reply by stephen huo - Monday, January 8, 2018 11:48 AM -
1 Votes
how to reuse the different set of stored procedure code for single ssis package to two different output flat file destinations.
This article describes how to handle multiple result sets in a script ...Answered | 4 Replies | 2286 Views | Created by Lakshmi S _AP - Tuesday, September 11, 2012 5:53 AM | Last reply by Joon84 - Tuesday, September 11, 2012 8:17 AM -
0 Votes
how to retive stored procedure output in SSIS 2008
and: please create new thread for new questions, if you look at title of this thread "how to retrieve stored ...Answered | 26 Replies | 6940 Views | Created by luckyforu2006 - Wednesday, January 12, 2011 9:35 AM | Last reply by luckyforu2006 - Friday, January 14, 2011 5:32 AM -
1 Votes
Two output files from orchestration
I really don't know what the output from the map execution (in the orchestration) is.Answered | 5 Replies | 747 Views | Created by SturlaJ - Wednesday, October 21, 2015 10:00 AM | Last reply by SturlaJ - Wednesday, October 21, 2015 12:23 PM -
1 Votes
Error when executing a stored procedure with output parameters
In a my pkg I have used an execute sql task to call a stored procedure in this manner: DECLARE @CountRec as int DECLARE @NameFile as ...Answered | 2 Replies | 4710 Views | Created by pscorca - Wednesday, November 18, 2009 5:18 PM | Last reply by Nitesh Rai - Wednesday, November 18, 2009 5:46 PM -
1 Votes
How to combine two Store procedure
But, I will prefer to dump data into one table from Stored procedures itself.Answered | 3 Replies | 748 Views | Created by Joining multiple Tables - Friday, June 12, 2015 2:48 PM | Last reply by Anuj Tripathi - Friday, June 12, 2015 3:24 PM -
1 Votes
How to execute stored procedure with output parameters
You have two options.Answered | 6 Replies | 17195 Views | Created by CT3 - Sunday, November 16, 2008 1:16 AM | Last reply by Jonuz - Monday, February 21, 2011 11:22 AM -
0 Votes
How to get data from oracle stored procedure with two output (refCursor and varchar2) parameters using dapper
Hi, I am using Dapper in my application I have a oracle stored procedure with ...Answered | 2 Replies | 3687 Views | Created by Kumar Jalli - Tuesday, September 8, 2015 3:26 PM | Last reply by messizhu - Wednesday, September 16, 2015 10:15 AM -
0 Votes
Parameter Mapping Output on Stored Procedure
create PROCEDURE OutputParameter @amount int, @Total int Output AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets ...Answered | 4 Replies | 778 Views | Created by DanHaf - Tuesday, June 6, 2017 1:06 PM | Last reply by Pirlo Zhang - Thursday, June 8, 2017 1:36 AM -
0 Votes
Getting Output value from a Stored Procedure in Execute SQL
I am trying to get two output parameters from Stored procedure.Answered | 18 Replies | 6005 Views | Created by A2H1986 - Wednesday, October 27, 2010 3:14 PM | Last reply by Reza Raad - Monday, November 8, 2010 4:46 AM -
9 Votes
Stored Procedure with an Output Variable for other Insert Queries
E.g. removed the OUTPUT parameter from parameter declaration and changed it to the local declaration of the variable in the body of the stored procedure?Answered | 28 Replies | 9067 Views | Created by tnswalker - Wednesday, December 12, 2012 3:32 PM | Last reply by Naomi N - Thursday, December 13, 2012 8:40 PM - Items 1 to 20 of 3423832 Next ›
No announcements
