No announcements
Found 689038 threads
-
0 VotesMultiple Result Sets
User1541399443 posted Using ASP.net 2.0 and C#, I am having trouble figuring out how I would access multiple result sets for a query like the ...Answered | 2 Replies | 11 Views | Created by Anonymous - Monday, March 19, 2007 12:33 PM | Last reply by Anonymous - Monday, March 19, 2007 2:32 PM
-
0 Votes
storage procedure returning multiple result sets
Answered | 1 Replies | 2183 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
Datareader with multiple result sets
/max pool size was reached" errors. Our concern is if the above approach of getting multiple result sets and passing sqldatareader to each function can cause ...Answered | 3 Replies | 27 Views | Created by Anonymous - Monday, July 13, 2015 6:27 PM | Last reply by Anonymous - Saturday, July 25, 2015 4:19 AM -
0 Votes
Stored procedures with multiple result sets
User1191240483 posted Hi, I have a requirement to access, through t-sql, records from multiple result sets returned from a stored ...Answered | 5 Replies | 5 Views | Created by Anonymous - Monday, March 19, 2007 2:22 PM | Last reply by Anonymous - Wednesday, March 21, 2007 11:38 PM -
0 Votes
multiple result sets vs mulitple data readers
User863284803 posted Ok - I am just wondering... Would it be better to have a sp return multiple result sets and use ...Answered | 1 Replies | 6 Views | Created by Anonymous - Friday, June 4, 2010 2:07 AM | Last reply by Anonymous - Friday, June 4, 2010 2:25 AM -
0 Votes
Multiple result sets
User863284803 posted I just want to get some clarification on multiple result sets and how to read them: so lets say my sp looks ...Answered | 2 Replies | 18 Views | Created by Anonymous - Saturday, October 25, 2008 3:19 AM | Last reply by Anonymous - Sunday, October 26, 2008 9:27 AM -
0 Votes
How to send Multiple Result sets to excel destination
Object. Now I need to send the multiple result sets to Excel destination. can some one please help me on how to achive thisAnswered | 1 Replies | 2635 Views | Created by nmittapalli - Friday, September 9, 2011 10:59 AM | Last reply by Jamie Thomson - Friday, September 9, 2011 11:51 AM -
1 Votes
how stored procedures return multiple result sets?
Returning multiple result sets You can have multiple queries inside a single sproc, as shown in the following sproc code:Answered | 3 Replies | 9457 Views | Created by seco - Sunday, January 28, 2007 3:29 PM | Last reply by Barry Andrew - Monday, January 29, 2007 11:45 AM -
0 Votes
Code first - Execute a procedure that results multiple result sets
Hi Carlos; Currently all version of Entity Framework up to 4.3 do not support multiple result sets being returned by a single stored ...Answered | 3 Replies | 3097 Views | Created by Carlos Marchi - Friday, March 30, 2012 6:21 PM | Last reply by Fernando Soto - MCSD - Monday, April 2, 2012 2:01 PM -
1 Votes
Returning multiple result sets from a procedure
You may refer this linkAnswered | 1 Replies | 739 Views | Created by G Srikar Reddy - Friday, February 28, 2014 3:31 PM | Last reply by Ch. Rajen Singh - Friday, February 28, 2014 5:16 PM -
0 Votes
Multiple Result Sets - dynamic SQL
Should I be able to pass procedure code like that shown below and get back multiple results sets via a Reader? Or? If I run the SQL below in the query tools (SQL ...Answered | 9 Replies | 5111 Views | Created by Bob Heitzman - Tuesday, August 24, 2010 5:30 PM | Last reply by Bob Heitzman - Wednesday, September 1, 2010 6:22 PM -
0 Votes
Create DataGridViews From Multiple Result Sets
Hi, I have a SQL Stored Procedure that returns multiple result sets. How do I create a DataGridView for each result ...Answered | 3 Replies | 3404 Views | Created by obrienkev - Wednesday, November 25, 2009 3:45 PM | Last reply by KouroshBM - Wednesday, July 25, 2012 11:57 AM -
0 Votes
get Multiple result sets returned from Stored procedures in EF
) supports handling multiple result sets through stored procedures. Hi, I am using VS 2010 and hence does not have EF 5. Yes ...Answered | 3 Replies | 66 Views | Created by Anonymous - Sunday, May 12, 2013 7:24 AM | Last reply by Anonymous - Monday, May 13, 2013 2:25 AM -
0 Votes
Multiple result sets and SqlDataReader
User863284803 posted I have two questions: 1) Is there a way I can retrieve the numbers of results sets in a DataReader? 2) Anyway to ...Answered | 1 Replies | 11 Views | Created by Anonymous - Sunday, November 2, 2008 8:57 PM | Last reply by Anonymous - Monday, November 3, 2008 12:52 AM -
4 Votes
Multiple Result Sets Using in SSRS
Data set usage in Reporting Services. I have a stored procedure which returns multiple Result Sets (result tables), and I created a Data set in Reporting Services ...Answered | 3 Replies | 20153 Views | Created by Raju Malla - Thursday, March 11, 2010 12:14 PM | Last reply by BI Analyst - Wednesday, November 7, 2012 9:53 AM -
0 Votes
DBDataReader and Multiple Result Sets
= 0 BEGIN SELECT ID, Name FROM EMPLOYEES END This returned two result sets. The first was empty and the second contained some employee information. ...Answered | 1 Replies | 12 Views | Created by Anonymous - Thursday, January 20, 2011 3:54 PM | Last reply by Anonymous - Thursday, January 20, 2011 4:09 PM -
0 Votes
multiple result sets with sqlsrv
This looks like php variable being reused, e.g. same '$stmt' being used to store the result of the first and second queries. RobAnswered | 4 Replies | 16677 Views | Created by Ken Roberts - Wednesday, July 20, 2011 3:21 AM | Last reply by Robert Johnson - Tuesday, July 26, 2011 9:22 AM -
0 Votes
Where can I find the code used in "Stored Procedures with Multiple Result Sets" article?
I would like to know where I can find the code that was used in the EF article Stored Procedures with Multiple Result Sets Please ...Answered | 1 Replies | 777 Views | Created by Param Pavar - Monday, July 8, 2013 4:52 PM | Last reply by Chester Hong - Wednesday, July 10, 2013 10:16 AM -
0 Votes
Multiple result sets support in Entity Framework 5.0?
Hi, Does Entity Framework 5.0 supports multiple result sets returning from stored procedures? If not, is there a plan for future work ...Answered | 1 Replies | 1648 Views | Created by itai2211 - Tuesday, November 20, 2012 7:47 PM | Last reply by Alexander Sun - Thursday, November 22, 2012 2:27 AM -
0 Votes
How to handle multiple result sets return from Stored Procedure
Hi all, I want to know how to handle multiple result sets return from Stored Procedure? I know one way ...Answered | 4 Replies | 7240 Views | Created by TomasLeung - Wednesday, August 22, 2007 5:22 PM | Last reply by mflancour - Wednesday, August 22, 2007 6:18 PM - Items 1 to 20 of 689038 Next ›
No announcements
