Questions tagged [multiple-resultsets]
103 questions
0
votes
0 answers
Nested Result set(Child and Parent) on same table
I'm using Entity framework to bring in the data to a mvc application.
The table contains 2 columns, One column contains the IDs(string) and other contains SQL Queries(string). I want to bring the data to a grid which will have 3 columns i.e. ID,…
D.Who
- 1
- 3
0
votes
1 answer
Handling multiple tables using List<> in MVC
Here is my prob, am new to mvc,
I have used a List<> to get Data from Store Procedure as below,
List lDetails = objDB.Sp_MM_GetDetails(ArticleURL).ToList();
Its working fine for me, but my SP returning 2 table of data.…
RaJesh RiJo
- 4,302
- 4
- 25
- 46
0
votes
1 answer
SQL Server 2008 Stored Procedure multiple SELECTS returned as one set
I'd like to write a SQL Server 2008 stored procedure which returns in one record:
Max Stock price for the year,
Min Stock price for the year,
Max Stock price for the month,
Min Stock price for the month
Reviewing previous posts I've tried select#1…
Mike S
- 157
- 3
- 13
0
votes
0 answers
How to use same resultSet.next() twice?
I want to use the resultSet.next() method twice. I mean, I have retrieved 15 rows of employee and their fund (type A, type B) details, within these 15 employees, I want to know how many A funds and B funds are mapped to each employees.
while…
user2462133
- 64
- 3
- 7
0
votes
1 answer
Returning multiple resultsets with EntityFramework repository
I am working on a code where I need Multiple tables as result of a stored procedure. I am using Entity Framework repository pattern. It returns and bind an IEnumerable object, but I need to bind it with multiple IEnumerables at the same time.
Can…
Pankaj Nema
- 165
- 2
- 13
0
votes
1 answer
Returning an Int and a Complex Type from a stored procedure using Entity Framework 5.0
I have a project where I have been given a stored procedure that I must use. It is used to create a new record in the database. It returns an Int32 which is the new ID of the record in the table. It also has a temp table where errors are stored and…
I can be anything
- 184
- 3
- 12
0
votes
0 answers
Can pandas work with multiple result sets?
Assuming the database and driver support nextset(), is there a way for me to use pandas to process multiple sets? I've only been working with pandas for a few days, so I'm not sure what I expect it to look like. My current workflow is df =…
Mark
- 999
- 9
- 19
0
votes
1 answer
php mysql join results set repeating data
I've read almost every other post that relates to my query and cant find a definitive answer - I apologise if this has already been answered.
Basically I have a products table and an images table, 1 product can have many images. It is my…
user3095078
- 5
- 2
0
votes
1 answer
Get multiple result sets from a SELECT query
I have a big table on postgresql and I want to get multiple result sets as an output of a SELECT query if is it possible ?
My table looks like this:
select * from dns_table
id | dns_name | ip_source | mac_source | …
midobAck
- 15
- 5
0
votes
0 answers
Oracle returning multiple recordset
How can i return multiple record set from a procedure without using cursor.I'm using cursor often for my query, as you know cursor tired system.Is there any way getting multiple data?
Goran Zooferic
- 371
- 8
- 23
0
votes
1 answer
MySql first result before and after result set
I've got this awful query where I use IFNULL to determine whether there is a result before and a result after my result set. The result set is determined by a period in time, see may 5th till may 10th. This period of time is visualised in my…
Mike de Klerk
- 11,906
- 8
- 54
- 76
0
votes
5 answers
Preferred way of retrieving row with multiple relating rows
I'm currently hand-writing a DAL in C# with SqlDataReader and stored procedures. Performance is important, but it still should be maintainable...
Let's say there's a table recipes
(recipeID, author, timeNeeded, yummyFactor, ...)
and a table…
Wikser
- 810
- 7
- 11
0
votes
2 answers
Return multiple result sets AND use result set 1 to filter result set 2
/* result 1 */
select Id, Name
from Items
/* result 2 */
select Id,
Alias
from ItemAliases
where Id in (
select Id, Name
from table abc
)
We use SQL Server 2008.
Using the above example, it should be pretty straightforward…
adam
- 2,930
- 7
- 54
- 89
0
votes
0 answers
The Entity Framework 4.0 and ASP.NET
How to get multiple result sets using Entity Data Framework from SQL Server?
For example, I need to get the Customer's personal and account details from a Stored Procedure that contains following queries
SELECT CustomerID,Name,Address FROM…
Anoop
- 379
- 4
- 14
0
votes
2 answers
Database query for desired results
I am using some filters to display the products. Filters like colors, price and stuff.
Link : http://www.applechain.com/products/iPod.php
I use this query
$sql = "Select *
from tbl_product
where device='iPhone'
and (color='$c1'
…
user1960856
- 31
- 4