No announcements
Found 3326403 threads
-
1 VotesReturning multiple result sets from a procedure
You may refer this linkAnswered | 1 Replies | 924 Views | Created by G Srikar Reddy - Friday, February 28, 2014 3:31 PM | Last reply by Chongtham Rajen Singh - Friday, February 28, 2014 5:16 PM
-
0 Votes
Stored procedure returning multiple result sets
The best solution would be to have it do the first select, then the second only if the first returns no results.Answered | 7 Replies | 1326 Views | Created by NickLiveTech - Thursday, June 5, 2014 8:46 PM | Last reply by Erland Sommarskog - Friday, June 6, 2014 1:54 PM -
0 Votes
storage procedure returning multiple result sets
Hi JoseVillalobos, There are a couple of nice articles about this topic: Walkthrough: Multiple Result Sets ...Answered | 1 Replies | 2292 Views | Created by JoseVillalobos - Sunday, August 19, 2012 2:14 AM | Last reply by Carlos Sardo - Sunday, August 19, 2012 7:51 PM -
0 Votes
EF and Store Procedure returning multiple result sets of complex types
results sets from the stored procedure when they are complex types.Answered | 4 Replies | 4866 Views | Created by Iceonovich - Thursday, November 10, 2011 8:11 PM | Last reply by Iceonovich - Monday, November 14, 2011 9:30 PM -
0 Votes
Stored Procedure Returning Multiple Result Sets and converting them into HTML OR XML
The following is the required informatión: Signature of the stored procedure (procedure name, parameter names and ...Answered | 12 Replies | 3921 Views | Created by Tauhid S - Tuesday, September 2, 2014 9:37 AM | Last reply by Jesús López - Thursday, September 4, 2014 3:11 PM -
0 Votes
Working with procedures that Return multiple result sets
TSQL is not capable of handling multiple result sets.Answered | 8 Replies | 5893 Views | Created by Computermike - Wednesday, July 27, 2016 2:00 PM | Last reply by Chris Sijtsma - Wednesday, July 27, 2016 8:06 PM -
0 Votes
Multiple results from one stored procedure
John, As Kalman suggested you can easily return multiple result sets from a single stored proc by executing multiple ...Answered | 2 Replies | 4205 Views | Created by John Basedow - Friday, November 6, 2009 5:00 PM | Last reply by Adam Tappis - Friday, November 6, 2009 6:50 PM -
0 Votes
Stored Procedure with multiple return types
> Alternatively, you can map the same procedure multiple times (one for each result set) and make sure you call the right mapped version of the ...Answered | 2 Replies | 5240 Views | Created by chrischang03 - Friday, May 28, 2010 3:22 PM | Last reply by chrischang03 - Sunday, May 30, 2010 6:23 PM -
0 Votes
returning multiple resultset from a stored procedure
You cannot express a multiple result sets from a stored procedure in the metadata files and so the EntityClient does not support this directly.Answered | 2 Replies | 6510 Views | Created by zeeshan hirani - Wednesday, September 2, 2009 3:20 PM | Last reply by Jeff Derstadt - MSFT - Wednesday, September 16, 2009 4:29 PM -
0 Votes
Stored procedure returns empty result set.
When the procedure has multiple statements you'll need to set nocount on at the top, and turn it back off before you return data.Answered | 6 Replies | 49617 Views | Created by Diversant_ - Tuesday, January 13, 2009 7:04 AM | Last reply by MoSnipe - Friday, April 4, 2014 2:23 PM -
1 Votes
insert into table one or Multiple result sets from stored procedure
Here is a system store procedure. you do not have to create one.Answered | 4 Replies | 14924 Views | Created by JawidK - Sunday, September 16, 2012 12:44 PM | Last reply by Kalman Toth - Thursday, September 20, 2012 10:24 PM -
0 Votes
Stored Procedure Returning Multiple Datasets
Orlanzo said: Hi All, Is it possible to consume and dispense multiple recordsets from a stored procedure in Integration ...Answered | 2 Replies | 4479 Views | Created by Orlanzo - Wednesday, December 31, 2008 2:30 PM | Last reply by Duane Douglas - Thursday, January 1, 2009 6:26 AM -
1 Votes
Materializing Multiple Entities returned from a Stored Procedure
It works ok, but I guess I really would like a cleaner way of doing it i.e. without having to manually define materializers and have to return multiple ...Answered | 3 Replies | 7389 Views | Created by Shane Hancock - Monday, April 11, 2011 8:46 AM | Last reply by Jackie-Sun - Thursday, April 14, 2011 2:52 AM -
0 Votes
how to concatenate results from multiple Store procedures
could be solved in the app level.Answered | 9 Replies | 4073 Views | Created by cat_ca - Thursday, May 10, 2012 5:44 PM | Last reply by pratyaharam - Friday, May 11, 2012 12:21 PM -
2 Votes
Retrieve data from stored procedure which has multiple result sets and insert into multiple tables
TSQL does not handle multiple result sets directly.Answered | 5 Replies | 5779 Views | Created by AmitSahoo - Friday, June 24, 2016 12:18 PM | Last reply by Tom Phillips - Friday, June 24, 2016 7:12 PM -
0 Votes
Result set for stored procedure
You can read it here: http://blogs.microsoft.co.il/blogs/gilf/archive/2009/03/13/mapping-stored-procedure-results-to-a-custom-entity-in-entity-framework.aspx Every ...Answered | 1 Replies | 3522 Views | Created by KentZhou - Thursday, September 3, 2009 3:34 PM | Last reply by Gil Fink - Thursday, September 3, 2009 4:48 PM -
0 Votes
multiple result sets from stored procedure+3 pges in report
Hi Eric LIu, I have large data set having 50,000 records.Answered | 6 Replies | 707 Views | Created by prasad127 - Sunday, November 18, 2018 5:58 AM | Last reply by prasad127 - Tuesday, November 20, 2018 11:12 PM -
0 Votes
How to call store procedure which return multiple result set with EF code first
Hi Mou_inn, You could also use the other two methods to achieve your requirement. like below: #Store Procedure.Answered | 8 Replies | 708 Views | Created by Sudip_inn - Thursday, September 15, 2016 3:13 PM | Last reply by Sudip_inn - Monday, September 26, 2016 11:38 AM -
0 Votes
how to return a table from a stored procedure in ssis
http://geekswithblogs.net/stun/archive/2009/03/05/mapping-stored-procedure-parameters-in-ssis-ole-db-source-editor.aspxAnswered | 6 Replies | 5735 Views | Created by priyanka sutrave - Wednesday, July 14, 2010 12:19 PM | Last reply by Manikandan S - Friday, July 16, 2010 12:43 PM -
1 Votes
How to get the return value from a stored procedure
There are typically two ways to return data from a stored procedure: result sets (SELECTs) or OUTPUT parameters.Answered | 3 Replies | 34864 Views | Created by Bipins - Thursday, September 23, 2010 3:06 PM | Last reply by Bipins - Wednesday, September 29, 2010 1:40 PM - Items 1 to 20 of 3326403 Next ›
No announcements
