No announcements
Found 3218655 threads
-
0 Votes
Multiple Tables return by Stotered Procedure using Linq
However, if you drag and drop a stored procedure in a Linq to Sql designer, you need to manually modify the code behind to get each table returned by the stored ...Answered | 2 Replies | 5024 Views | Created by GuptaAlok12 - Wednesday, August 11, 2010 4:42 AM | Last reply by liurong luo - Monday, August 16, 2010 9:18 AM -
2 Votes
does WCFSQL adapeter supports returing mutiple result sets returened from Stored procedure
Yes ,You can get multiple result set depending on what your sql stored procedure is returning as an output .Answered | 3 Replies | 656 Views | Created by Ammu_Biz - Wednesday, October 21, 2015 6:00 PM | Last reply by Abhishek0127[Abhishek kumar] - Thursday, October 22, 2015 6:38 AM -
0 Votes
Return type for the stored procedure could not be detected.
Hello, The issue may caused by the mutiple results in the stored procedure, please refer to the following blog to solve this ...Answered | 4 Replies | 8671 Views | Created by Omnipotent06 - Monday, May 27, 2013 3:43 PM | Last reply by Naomi N - Tuesday, May 28, 2013 3:22 AM -
0 Votes
Combine two stored procedure results
Hi mahima i also found same solution as define in ...Answered | 5 Replies | 17270 Views | Created by mahima - Thursday, March 8, 2007 11:05 PM | Last reply by Waqas Silat - Saturday, August 25, 2012 12:47 PM -
0 Votes
How do I return a set of values from a SELECT as one of the return values from a stored procedure
I want to return the result of this select as the second field in each row of the result set.Answered | 17 Replies | 843 Views | Created by JimNickFL - Wednesday, August 19, 2015 2:29 AM | Last reply by Naomi N - Wednesday, August 19, 2015 2:41 PM -
2 Votes
problem returning decimal value from stored procedure
Now, for the original Question, the problem is not with the stored procedure returning values, as you have seen in ...Answered | 8 Replies | 23431 Views | Created by Bhaskar Ravindranath - Wednesday, May 7, 2008 6:37 AM | Last reply by Dan Guzman - Sunday, April 8, 2012 1:38 AM -
2 Votes
Results of store procedure in email attachment
Hi thankz for ur time i was able to save result of store procedure to file but the problem im having right now is results are saved in ...Answered | 2 Replies | 3601 Views | Created by mm6991 - Thursday, June 7, 2012 3:13 PM | Last reply by mm6991 - Thursday, June 7, 2012 5:57 PM -
0 Votes
Stored Procedures returning Scalar Values
You can read it ...Answered | 2 Replies | 3361 Views | Created by Iwan de Beer - Tuesday, July 7, 2009 5:46 AM | Last reply by Iwan de Beer - Wednesday, July 8, 2009 7:55 PM -
0 Votes
How can I treat a Stored Procedure Result Set as a Table?
GO CREATE PROCEDURE p1 AS SET NOCOUNT ON; SELECT 1 AS c1; GO DECLARE @t TABLE (c1 ...Answered | 14 Replies | 4998 Views | Created by tcarnes - Thursday, January 14, 2010 8:07 PM | Last reply by Hunchback - Friday, January 15, 2010 6:22 PM -
3 Votes
Multiple Tables returned from a Stored Procedure
Hi Ivan, Could you please show us your stored procedure and a code snippet of your application?Answered | 3 Replies | 22460 Views | Created by Ivan Sammut - Monday, July 25, 2011 10:58 AM | Last reply by BonnieB - Thursday, August 4, 2011 1:35 AM -
0 Votes
Process table columns from result Store procedure to another store procedure
Hi, I did exactly what u did the below screen shot is the first SP which produce ...Answered | 8 Replies | 1032 Views | Created by Thangam - Kasim - Monday, August 11, 2014 12:04 PM | Last reply by Charlie Liao - Tuesday, August 19, 2014 3:13 AM -
0 Votes
how to call tabular function in store procedure which returns multiple values
We can also use OUT parameter in stored procedure to return value at the calling portion.Answered | 1 Replies | 1050 Views | Created by Parul Gaur - Saturday, November 23, 2013 11:25 AM | Last reply by Chongtham Rajen Singh - Saturday, November 23, 2013 12:15 PM -
0 Votes
when iam exeuting the stored procedure it will give two result sets?
Here's a very simple example merging two result sets into one.Answered | 5 Replies | 1393 Views | Created by Ychinnari - Monday, July 29, 2013 4:13 AM | Last reply by SQLZealots - Tuesday, July 30, 2013 8:28 AM -
1 Votes
Reading Stored Procedure Recordsets
In the SQL Server Denali we can utilize multiple result sets.Answered | 12 Replies | 17436 Views | Created by Ali Haghighat dana - Saturday, January 2, 2010 4:16 AM | Last reply by Crakdkorn - Thursday, September 27, 2012 3:00 PM -
0 Votes
Transfer Stored Procedure's result into table
Is it possible to Transfer Stored Procedure's result into table in SQL 2005?Answered | 3 Replies | 5314 Views | Created by sesquipedalian - Wednesday, February 9, 2011 8:47 PM | Last reply by Kalman Toth - Tuesday, February 15, 2011 3:22 PM -
0 Votes
Application security settings to override results of stored procedure
The only thing that will be missing from the stored procedure's selection logic is the session activity refresh, but that can be done using other means ...Answered | 3 Replies | 6220 Views | Created by Groupe-CDGI Developper - Tuesday, December 23, 2008 3:12 PM | Last reply by Groupe-CDGI Developper - Tuesday, December 23, 2008 6:46 PM -
0 Votes
Returning a value from stored procedure with OUT parameter
Hi, you need to do like this alter PROCEDURE [dbo].Answered | 2 Replies | 4535 Views | Created by Podlesnick - Tuesday, April 12, 2011 7:44 AM | Last reply by Podlesnick - Tuesday, April 12, 2011 10:02 AM -
0 Votes
executing store procedures based on the store procedure select query results
Note that this assumes that you store procedure name and parameter value separately.Answered | 2 Replies | 469 Views | Created by Primaryracer - Monday, July 31, 2017 1:46 PM | Last reply by Primaryracer - Thursday, August 3, 2017 12:10 PM -
0 Votes
With .NET 3.5 is there any way to get results from a stored procedure
The SP returns data from 2 databases, I do not have just one table containing all the returned columns.Answered | 6 Replies | 1815 Views | Created by Ofer Gal - Wednesday, August 8, 2012 7:38 AM | Last reply by Fernando Soto - MCSD - Wednesday, August 8, 2012 3:56 PM -
1 Votes
Stored procedure executed in stored procedure
I think if we know the structure of the returned result, then using temp table should be good.Answered | 4 Replies | 5219 Views | Created by lgPerf - Wednesday, April 27, 2011 2:12 PM | Last reply by Naomi N - Wednesday, April 27, 2011 3:04 PM
No announcements