No announcements
Found 3218547 threads
-
1 VotesStored Procedure Result to CSV File
You can use bcp to export stored procedure results to flat file.Answered | 6 Replies | 31176 Views | Created by lokesh1986 - Wednesday, April 21, 2010 12:47 PM | Last reply by Thamizhmani T - Sunday, May 7, 2017 7:53 AM
-
0 Votes
How to execute result of stored procedure into temp table ?
Hi engahmedbarbary, Dynamic SQL is inside the SQL stored procedure and when we need to view the metadata of stored procedure having dynamic ...Answered | 8 Replies | 1290 Views | Created by engahmedbarbary - Saturday, May 9, 2020 1:26 PM | Last reply by Lily Lii - Tuesday, May 12, 2020 7:37 AM -
0 Votes
Select returns different results when used in stored procedure
Also, are you using parameter for that name or the direct value in the stored procedure?Answered | 4 Replies | 2064 Views | Created by Dewitt1061 - Tuesday, August 7, 2012 8:49 PM | Last reply by Erland Sommarskog - Tuesday, August 7, 2012 9:49 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 | 5384 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
Is it possible to extract the results of stored procedure using SSIS?
Summary of the solution: We need to create an SSIS solution that will execute a stored procedure from a dynamic connection and extract the ...Answered | 4 Replies | 4572 Views | Created by sqlsantos - Wednesday, March 10, 2010 7:16 PM | Last reply by sqlsantos - Thursday, March 18, 2010 9:10 PM -
2 Votes
How to save return value from store procedure in ssis and use that value to call another store procedure?
do you want to run the stored procedure sp_123 in second execute sql task?Answered | 13 Replies | 25039 Views | Created by mndrs5 - Monday, November 22, 2010 9:48 PM | Last reply by mndrs5 - Monday, November 29, 2010 7:19 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 | 4579 Views | Created by Podlesnick - Tuesday, April 12, 2011 7:44 AM | Last reply by Podlesnick - Tuesday, April 12, 2011 10:02 AM -
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 | 1833 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 -
0 Votes
Calling multiple stored procedure from same Orchestration
type=forum&referrer=http://social.technet.microsoft.com/Forums/en-US/351b6d62-d085-4ab4-a000-f7c16c780f15/calling-multiple-stored-procedure-from-same-orchestrat ...Answered | 2 Replies | 967 Views | Created by Rajesh Ranjan BizUser - Friday, January 24, 2014 8:31 PM | Last reply by Rajesh Ranjan BizUser - Friday, January 24, 2014 8:36 PM -
0 Votes
How Populate Multiple Result sets to Diffrents Sheets in One Excel Workbook Dynamically through Stored Procedure in SSIS
make 2 SP first one create proc multipleresultsetFIRST(@empid int) as begin select * ...Answered | 4 Replies | 6579 Views | Created by Kiran Reddy A - Sunday, March 4, 2012 8:57 AM | Last reply by Nik - Shahriar Nikkhah - Sunday, March 4, 2012 11:59 PM -
1 Votes
Stored procedure returning integer instead of ISingleResult
This usually happens when the stored procedure has multiple results or uses a temp table.Answered | 18 Replies | 24640 Views | Created by Dhanjel - Wednesday, January 2, 2008 7:49 AM | Last reply by Rajat OO7 - Monday, August 20, 2012 1:10 PM -
1 Votes
insert results from stored procedure to new table
thank you, is there a way to "script out" all the columns and their type from the procedure itself?Answered | 5 Replies | 5396 Views | Created by elHugo - Tuesday, January 12, 2010 10:42 PM | Last reply by Manigandan A - Wednesday, January 13, 2010 6:01 AM -
0 Votes
Executing Multiple Stored Procedure
Based on the information in this post ( https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7f1bea3e-0feb-43e1-aaaf-0cf36253f264/how-to-execute-multiple-sql-statements-in-parallel-?Answered | 2 Replies | 893 Views | Created by lilutchay - Tuesday, February 12, 2019 5:43 PM | Last reply by Tom Cooper - Tuesday, February 12, 2019 8:15 PM -
2 Votes
Handling Store Procedure in SSRS
Sathish, Its not possible to retrive different resultsets from a single stored procedure into different dataset.Answered | 3 Replies | 1474 Views | Created by aluvala vijay - Thursday, January 30, 2014 6:13 AM | Last reply by Harish83 - Thursday, January 30, 2014 6:47 AM -
3 Votes
selecting the latest return table from a stored procedure.
EXEC sp_serveroption linked_server , 'data access' , 'true' go use pubs go create procedure ...Answered | 5 Replies | 4377 Views | Created by Pacerier - Sunday, December 26, 2010 5:26 PM | Last reply by Pacerier - Monday, December 27, 2010 10:36 AM -
0 Votes
Call Stored Procedure Multiple times
Hi Uzzal Kumar Hore, For your second question, you could also get some ideas from this one: CREATE TABLE [dbo].Answered | 4 Replies | 1149 Views | Created by Uzzal Kumar Hore - Sunday, September 15, 2019 7:56 AM | Last reply by Sabrina Zhang - Monday, September 16, 2019 6:49 AM -
0 Votes
How do I get last result in stored procedure?
When I replaced that with SELECT @NumRow=count(*) from @myTemp, the multiple data set issue went away.Answered | 4 Replies | 3690 Views | Created by Wonger - Wednesday, January 13, 2010 4:37 PM | Last reply by Wonger - Wednesday, January 13, 2010 9:02 PM -
1 Votes
Capture of "return" value from stored procedures
Hello rpi, you can change the return statements for select statements and then you can call the stored procedure and cast the value returned to an Int32.Answered | 1 Replies | 3380 Views | Created by r31416 - Sunday, May 8, 2011 9:16 PM | Last reply by Miguel Fernández Corral - Monday, May 9, 2011 12:12 AM -
5 Votes
Return Value in stored Procedure
But you should generally prefer a return value over an out param.Answered | 5 Replies | 2511 Views | Created by A Shashi - Monday, June 18, 2012 1:11 PM | Last reply by Chuck Pedretti - Monday, June 18, 2012 1:34 PM -
1 Votes
Calling Stored Procedure with Multiple Parameters from IOS
Hi Phillip, Both setting the query parameters and using [query readWithCompletion..Answered | 3 Replies | 1510 Views | Created by Michelle McCabe - Sunday, September 21, 2014 10:08 AM | Last reply by Michelle McCabe - Monday, September 22, 2014 7:29 AM
No announcements
