No announcements
Found 2772269 threads
-
0 VotesReturn 2 result sets
Hi, I'm trying to return 2 different result sets using the below query mapped to 2 different variables in my execute sql task. I've tried this with one task andAnswered | 4 Replies | 4432 Views | Created by mr4100 - Friday, February 29, 2008 3:54 PM | Last reply by mr4100 - Friday, February 29, 2008 4:27 PM
-
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 | 9 Views | Created by Anonymous - Saturday, October 25, 2008 3:19 AM | Last reply by Anonymous - Sunday, October 26, 2008 9:27 AM -
0 Votes
Implementing a stored procedure returning the different result
is involve different types for complexity imagine you need to return rows from 2 different tables, then you would have to configure your WCF to accept multiple ...Answered | 3 Replies | 1935 Views | Created by byHesed - Thursday, January 3, 2013 3:56 PM | Last reply by byHesed - Tuesday, January 15, 2013 10:41 AM -
0 Votes
Stored procedure returning multiple result sets
@failoverLocale = '') BEGIN EXEC dbo.myTestProc ...Answered | 7 Replies | 1046 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
Can SSRS 2008 handle stored procedures which return multiple tables ?
Reporting Services supports stored procedures that return only one set of data. If a stored procedure returns multiple result sets, only ...Answered | 3 Replies | 16165 Views | Created by Akshay_Jadhav - Tuesday, January 4, 2011 11:05 AM | Last reply by Akshay_Jadhav - Wednesday, January 5, 2011 6:30 AM -
0 Votes
two result sets from stored procedure..
is an arraylist totalvalue=CInt(b(1)) label1.Text=totalvalue.ToString() my aspx page shows only the second item - total, I cannot ...Answered | 6 Replies | 6 Views | Created by Anonymous - Thursday, June 12, 2008 8:34 AM | Last reply by Anonymous - Thursday, June 12, 2008 9:22 AM -
1 Votes
WFC RIA Service - Result from Stored Procedures...
Procedures because the result is nit mapped to an existing table. Is it possible to create a Domain Service class and use nativ ADO.NET to execute the ...Answered | 3 Replies | 973 Views | Created by Mad Rian - Thursday, October 17, 2013 3:51 PM | Last reply by Mad Rian - Monday, October 21, 2013 2:04 PM -
0 Votes
How would write a Sql class to populatehydrate my model class
Execute Stored Procedures Returning Multiple Result SetsAnswered | 2 Replies | 5 Views | Created by Anonymous - Sunday, March 30, 2014 12:07 PM | Last reply by Anonymous - Monday, March 31, 2014 5:48 PM -
0 Votes
Using result sets from a stored procedure
Is it possible to access the result set returned from a stored procedure?For example,begin set @cursor_list = sp_spaceused 'a_table'  Answered | 4 Replies | 8771 Views | Created by ToryPatnoe - Tuesday, November 15, 2005 6:11 PM | Last reply by - Tuesday, November 15, 2005 6:42 PM -
0 Votes
multiple result sets from stored procedure+3 pges in report
should have all 100000 records. Please suggest me best way to implement.(can i combine all result sets using union operator in stored procedure and fill ...Answered | 6 Replies | 545 Views | Created by prasad127 - Sunday, November 18, 2018 5:58 AM | Last reply by prasad127 - Tuesday, November 20, 2018 11:12 PM -
0 Votes
storage procedure returning multiple result sets
Answered | 1 Replies | 2178 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
Can't SSRS 2008 handle stored procedures which return multiple tables?
User1471008070 posted Hi, Reporting Services supports stored procedures that return only one set of data. If a stored ...Answered | 2 Replies | 5 Views | Created by Anonymous - Wednesday, October 13, 2010 10:24 AM | Last reply by Anonymous - Tuesday, October 19, 2010 4:15 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 ...Answered | 1 Replies | 5 Views | Created by Anonymous - Thursday, January 20, 2011 3:54 PM | Last reply by Anonymous - Thursday, January 20, 2011 4:09 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 | 3397 Views | Created by obrienkev - Wednesday, November 25, 2009 3:45 PM | Last reply by KouroshBM - Wednesday, July 25, 2012 11:57 AM -
0 Votes
How to return Values from stored procedures?
i know, how to return list of values(single column values) from stored procedures in sqlserver ...Answered | 4 Replies | 0 Views | Created by Anonymous - Friday, August 13, 2010 12:54 AM | Last reply by Anonymous - Tuesday, August 17, 2010 9:22 AM -
0 Votes
Multiple Active Result Sets
I think ı can't do it with using stored procedure. because i want to fill collections at the same time. out of necessity i must use marsAnswered | 5 Replies | 6628 Views | Created by caseofficer - Thursday, March 29, 2007 8:09 PM | Last reply by Arnie Rowland - Monday, April 2, 2007 5:48 AM -
0 Votes
Employing DataSets Where the Stored Procedure has multiple Return sets
Hi RptRep, The stored procedure will return one data set of the all result sets. However, you can add theAnswered | 5 Replies | 3870 Views | Created by RptRep - Tuesday, August 19, 2008 1:03 PM | Last reply by Su_man - Thursday, March 5, 2009 5:30 AM -
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 | 2 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 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 | 5 Views | Created by Anonymous - Sunday, November 2, 2008 8:57 PM | Last reply by Anonymous - Monday, November 3, 2008 12:52 AM -
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. You can try this: httpAnswered | 5 Replies | 3853 Views | Created by AmitSahoo - Friday, June 24, 2016 12:18 PM | Last reply by Tom Phillips - Friday, June 24, 2016 7:12 PM
No announcements
