No announcements
Found 3218655 threads
-
0 Votes
Exporting Stored Procedure results to Excel
Goal: To run a stored procedure and export its results to Excel.Answered | 7 Replies | 4693 Views | Created by Ravi Gehlot - Tuesday, June 30, 2015 8:27 PM | Last reply by Ravi Gehlot - Thursday, July 9, 2015 12:35 PM -
0 Votes
How to return the result set of multiple select statements as one result set?
the tables I am working on have several columns and they are from different data types. what I wanted to do is to add two more columns to the resultsetAnswered | 2 Replies | 1126 Views | Created by Developer life - Tuesday, September 23, 2014 10:17 PM | Last reply by Developer life - Wednesday, September 24, 2014 4:28 AM -
0 Votes
Stored procedure with result
> 0 if successful otherwise the error code Do you mean if the stored procedure successful, it will return 0, otherwise, it will return an ...Answered | 1 Replies | 525 Views | Created by Russ356 - Wednesday, March 23, 2016 1:14 PM | Last reply by Weiwei Cai - Monday, March 28, 2016 8:13 AM -
0 Votes
Return multiple entities from stored procedure in Entity Framwork
Please see the link below http://blogs.msdn.com/b/efdesign/archive/2008/07/18/using-stored-procedures-to-get-load-structured-data.aspxAnswered | 2 Replies | 3542 Views | Created by Mustehsan Ikram - Thursday, June 24, 2010 7:26 AM | Last reply by TheKiller556 - Thursday, June 24, 2010 7:47 AM -
0 Votes
Multiple outputs from store procedure
One of the method is to execute stored procedure from ORACLE with multiple cursors result and fill multiple object collection.Answered | 2 Replies | 6784 Views | Created by Gohan - Wednesday, March 23, 2011 5:37 PM | Last reply by Francis Marasigan - Friday, March 25, 2011 9:53 PM -
2 Votes
stored procedure return code
Try this: CREATE PROCEDURE dbo.TestProcedure AS BEGIN PRINT '----------------- In sp before delay -----------------' WAITFOR DELAY '00:00:10' ...Answered | 3 Replies | 3695 Views | Created by Pete Newman - Wednesday, December 14, 2011 10:51 AM | Last reply by HeSitated - Wednesday, December 14, 2011 11:00 AM -
0 Votes
Population table from result obtained by a stored procedure
You can use INSERT EXECUTE, but the number of columns returned by SP should match the prepared table (it could be a temp table with the exact same structure as the expected result).Answered | 1 Replies | 5381 Views | Created by vishal.... _ - Wednesday, March 17, 2010 2:10 AM | Last reply by Naomi N - Wednesday, March 17, 2010 2:23 AM -
0 Votes
Can you return multiple resultsets in a stored procedure using Entity Framework
When I imported my stored procedure as a Function Import it required me to select a return type (None, Scalar, Complex, or Entities).Answered | 3 Replies | 7579 Views | Created by Chockalingam S - Wednesday, July 27, 2011 6:58 PM | Last reply by dat1 - Wednesday, March 7, 2012 4:52 PM -
0 Votes
Returning html from stored procedure
Function can return a scalar value or a table.Answered | 2 Replies | 6077 Views | Created by tsk238 - Thursday, February 17, 2011 4:22 PM | Last reply by Naomi N - Thursday, February 17, 2011 6:01 PM -
4 Votes
Multiple Result Sets Using in SSRS
Hi, Thank you for your Reply. i change my stored procedure Result Set Order.Now its working Fine.Answered | 3 Replies | 20560 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
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 | 8673 Views | Created by Omnipotent06 - Monday, May 27, 2013 3:43 PM | Last reply by Naomi N - Tuesday, May 28, 2013 3:22 AM -
1 Votes
Call a stored procedure from a stored procedure
How do I get the values returned by the SP into one result set?Answered | 5 Replies | 1604 Views | Created by Dave Parker - Saturday, October 5, 2013 2:30 AM | Last reply by Chongtham Rajen Singh - Sunday, October 13, 2013 1:46 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
Combine two stored procedure results
Hi mahima i also found same solution as define in ...Answered | 5 Replies | 17273 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
Stored procedure return value conflicting with trigger results
The procedure has the possibility of inserting 0 rows in which case it would return -2.Answered | 10 Replies | 3602 Views | Created by Meghah24 - Friday, July 22, 2011 1:44 PM | Last reply by Meghah24 - Saturday, July 23, 2011 5:08 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 | 3603 Views | Created by mm6991 - Thursday, June 7, 2012 3:13 PM | Last reply by mm6991 - Thursday, June 7, 2012 5:57 PM -
0 Votes
Best Practice for returning rows from a stored procedure
(Use a sql task that puts the results into a result set?Answered | 10 Replies | 4344 Views | Created by ckbkyne - Tuesday, October 13, 2009 7:27 PM | Last reply by ckbkyne - Wednesday, October 14, 2009 1:32 PM -
0 Votes
Different results in Stored Procedure and in the report
Hi DReddyC, According to your description, the stored procedure contains a parameter, when you run the procedure in dataset, it can return ...Answered | 2 Replies | 700 Views | Created by DReddyC - Wednesday, October 21, 2015 6:39 PM | Last reply by Qiuyun Yu - Thursday, October 22, 2015 6:36 AM -
0 Votes
Stored Procedure to return results in chunks??
CREATE PROCEDURE spPaging AS DECLARE @page_size INT;Answered | 4 Replies | 5083 Views | Created by IshNair - Thursday, April 5, 2012 8:14 AM | Last reply by IshNair - Monday, April 9, 2012 6:15 AM -
0 Votes
Stored procedure return value
Is it possible now to get a *real* return value of a stored procedure?Answered | 11 Replies | 72779 Views | Created by Tom_A_B - Friday, July 18, 2008 1:09 PM | Last reply by Eldis - Tuesday, May 12, 2009 10:19 AM
No announcements