No announcements
Found 4073293 threads
-
0 VotesHow do I Call a Stored Procedure in SSRS
The Parameters tab of the Dataset dialog box allows you to map report parameters to the input parameters of the stored procedure.Answered | 3 Replies | 4047 Views | Created by Craig Alaniz - Wednesday, March 18, 2009 3:42 PM | Last reply by ShilpaReddy - Friday, March 20, 2009 9:40 AM
-
1 Votes
how can I calling a stored procedure from another stored procedure
An alternative could be for the inner proc to return the value using an output parameter instead of returning a result set ...Answered | 1 Replies | 1030 Views | Created by sa ba - Thursday, May 9, 2019 6:21 AM | Last reply by TiborK - Thursday, May 9, 2019 6:57 AM -
1 Votes
Call a stored procedure from a stored procedure
How do I get the values returned by the SP into one result set?Answered | 5 Replies | 1601 Views | Created by Dave Parker - Saturday, October 5, 2013 2:30 AM | Last reply by Chongtham Rajen Singh - Sunday, October 13, 2013 1:46 AM -
0 Votes
how do i call a stored procedure with no tracking option
Well, come to think of it, you can accomplish this in beta 1 by using ExecuteStoreQuery which has an overload that takes a merge option, but I believe there will be a more direct way to ...Answered | 3 Replies | 5943 Views | Created by zeeshan hirani - Thursday, May 21, 2009 6:16 AM | Last reply by simmdan - Thursday, May 21, 2009 7:25 PM -
3 Votes
How to call Stored Procedure from Entity Framework?
The way how you call stored procedure from EF will be still the same.Answered | 5 Replies | 33922 Views | Created by h_maksuda - Friday, May 27, 2011 7:39 PM | Last reply by Dibu.net - Friday, August 30, 2013 5:50 AM -
0 Votes
how to do documentation for stored procedures..
* Subsystem : none * Purpose/Description : This SP is created to * Input : * Output : * ...Answered | 5 Replies | 943 Views | Created by LuckyLucky12 - Tuesday, October 14, 2014 4:34 AM | Last reply by Erland Sommarskog - Tuesday, October 14, 2014 10:50 AM -
0 Votes
How do I get a stored procedure to NOT return outputs from other stored procedures it runs.
I have a stored procedure that is used throughout an application.Answered | 17 Replies | 4133 Views | Created by dbixby001 - Thursday, December 3, 2009 9:25 PM | Last reply by PeterParkerNeo - MCTS, MCITP - Monday, December 7, 2009 6:33 AM -
0 Votes
how to call a stored procedure in ssis
There are, not one, but multiple ways of calling an SP in SSIS.Answered | 3 Replies | 2822 Views | Created by suresh Nelluri - Monday, May 21, 2012 1:58 PM | Last reply by SQL Novice 01 - Monday, May 21, 2012 2:41 PM -
1 Votes
Calling web service from a SQL stored procedure
Earlier I was planning to use OA procedures but all the blogs I found call asmx and method e.g.Answered | 5 Replies | 12640 Views | Created by gpshukla - Monday, November 25, 2013 5:27 PM | Last reply by WSDeveloper - Thursday, February 22, 2018 12:20 PM -
0 Votes
Execution Times of Stored Procedures Called from Other Stored Procedures
CREATE PROC z1SP AS SELECT * FROM Production.Product; GO CREATE PROC z2SP AS SELECT * FROM Production.Product WHERE Color is not null; EXEC ...Answered | 1 Replies | 1009 Views | Created by miguelh - Tuesday, December 16, 2014 3:41 PM | Last reply by Kalman Toth - Tuesday, December 16, 2014 6:05 PM -
0 Votes
calling function from stored procedure
When i calling a function inside stored proc, then calling the proc It gives me this error: Only functions and extended stored ...Answered | 1 Replies | 3678 Views | Created by Mohraiel - Thursday, January 14, 2010 1:00 PM | Last reply by haberman michael - Thursday, January 14, 2010 1:13 PM -
1 Votes
How do I call an SSRS Report from a stored procedure, and pass parameters?
Hi all, I have a Report, that I want to run ad-hoc from a Stored Procedure.Answered | 4 Replies | 22445 Views | Created by jasonwisdom - Tuesday, October 12, 2010 7:07 PM | Last reply by LaSabr3 - Monday, July 15, 2013 7:23 PM -
1 Votes
How do I find the stored procedures?
Hi Jamie, Alternatively run this on your database: 'select * from sys.objects where type ...Answered | 2 Replies | 3418 Views | Created by jamiedewamie - Tuesday, July 26, 2011 2:02 PM | Last reply by Stephen Archbold - Tuesday, July 26, 2011 2:30 PM -
0 Votes
Call Stored Procedure With Parameters
Within the procedure set that variable.Answered | 1 Replies | 880 Views | Created by All-we-know-is-what-we-are-told - Monday, October 19, 2015 4:04 PM | Last reply by Tom Groszko - Monday, October 19, 2015 5:51 PM -
0 Votes
Calling a stored procedure from data flow
You can't use an OLE DB Destination for an UPDATE statement - but do a quick search for how to use a stored procedure with SSIS, and I think you'll find a ...Answered | 5 Replies | 10702 Views | Created by SKK_ - Monday, April 13, 2009 5:13 PM | Last reply by SKK_ - Monday, April 13, 2009 11:55 PM -
0 Votes
How do i remove Stored procedures from the database permanantly?
Hi friend, i wasnt ware of the fact that ic ould delete the procedure from F7 window :) ... thanksAnswered | 7 Replies | 3648 Views | Created by code_warrior - Thursday, December 10, 2009 1:48 PM | Last reply by code_warrior - Thursday, December 10, 2009 4:46 PM -
0 Votes
call cobol from MS SQL stored procedure
I have never used that compiler, I can't give you any more detailed information.Answered | 6 Replies | 1722 Views | Created by Selvakumar Thangaraj - Wednesday, June 17, 2015 6:02 AM | Last reply by AV111 - Thursday, June 18, 2015 1:39 AM -
0 Votes
Calling a stored procedure
Is there a step-by-step procedure as well for BizTalk 2006 R2 that shows how to insert records from an EDI file into SQL Server 2005 by calling a stored ...Answered | 10 Replies | 11253 Views | Created by SQLUser1979 - Thursday, July 10, 2008 12:49 AM | Last reply by BenoitB1 - Friday, March 20, 2009 12:22 PM -
2 Votes
Calling a stored procedure in a function
I can not use stored procedure as i have to use that function in crystal reports.Answered | 9 Replies | 15985 Views | Created by Amit Govil (MCC) - Monday, January 10, 2011 12:35 PM | Last reply by Kent Waldrop _ - Wednesday, January 12, 2011 1:58 PM -
2 Votes
How to call a stored procedure in Execute SQL task?
Hi allan, You can drag the Execute SQL Task from the ToolBox to the control flow, and then configure the SQL Statement node as below(SPName represent ...Answered | 2 Replies | 36805 Views | Created by allan8964 - Tuesday, January 3, 2012 4:43 AM | Last reply by Eileen Zhao - Wednesday, January 4, 2012 10:23 AM - Items 1 to 20 of 4073293 Next ›
No announcements
