No announcements
Found 1735381 threads
-
0 VotesPopulation 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 ...Answered | 1 Replies | 5431 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
Stored Procedure To Populate Multiple Tables
Something like that (untested): CREATE PROCEDURE [dbo].Answered | 1 Replies | 5957 Views | Created by runnerpaul - Friday, June 1, 2012 9:53 AM | Last reply by Dmitri Korotkevitch - Friday, June 1, 2012 1:28 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 | 5373 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
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 | 1067 Views | Created by Thangam - Kasim - Monday, August 11, 2014 12:04 PM | Last reply by Charlie Liao - Tuesday, August 19, 2014 3:13 AM -
1 Votes
insert results from stored procedure to new table
wait what if I just grab the code from the procedure and wrap it all up into a select * into somenewtable from (code from stored ...Answered | 5 Replies | 5387 Views | Created by elHugo - Tuesday, January 12, 2010 10:42 PM | Last reply by Manigandan A - Wednesday, January 13, 2010 6:01 AM -
1 Votes
Call a stored procedure from a stored procedure
the result set obtained by the select.Answered | 5 Replies | 1695 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 -
0 Votes
Store results of Stored Procedures into table using SSIS
Yes You can use query inside SP itself to get it stored in a table ie like CREATE PROC [dbo].Answered | 2 Replies | 1457 Views | Created by Naveen_kumar - Tuesday, August 2, 2016 6:45 AM | Last reply by Visakh16 - Tuesday, August 2, 2016 7:07 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 | 1276 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
Stored Procedure with Temp table and CTE gives no results
So first a simple test: replace the CTE with a simple SELECT * FROM #t1 ; in your procedure, this should return the 112687 records.Answered | 3 Replies | 5314 Views | Created by Hennie_Ergon - Monday, April 11, 2011 7:27 AM | Last reply by Nigel Rivett - Monday, April 11, 2011 9:03 AM -
0 Votes
Multiple results from one stored procedure
John, As Kalman suggested you can easily return multiple result sets from a single stored proc by executing multiple SELECT queries.Answered | 2 Replies | 4201 Views | Created by John Basedow - Friday, November 6, 2009 5:00 PM | Last reply by Adam Tappis - Friday, November 6, 2009 6:50 PM -
0 Votes
Tool to obtain the Colmn names and the table names from a given Stored Procedure.
Hi Abdul, Please also refer to this custom VB function in this article: Get Column name From Stored ...Answered | 2 Replies | 2973 Views | Created by Abdul Arsath - Monday, September 26, 2011 10:09 AM | Last reply by Sharp Wang - Friday, September 30, 2011 9:16 AM -
0 Votes
insert result of stored procedure in new table
Thank you All I should create table first and then insert into..Answered | 3 Replies | 4015 Views | Created by irmorteza - Thursday, September 16, 2010 2:35 PM | Last reply by irmorteza - Thursday, September 16, 2010 3:02 PM -
6 Votes
How to INSERT INTO TABLE FROM STORED PROCEDURE RESULT (Multi row)
You can use the INSERT...EXEC syntax to insert the stored procedure resultset into the target table.Answered | 10 Replies | 2040 Views | Created by Master Can - Thursday, October 16, 2014 3:47 AM | Last reply by Avijit Swain - Thursday, October 16, 2014 10:03 AM -
0 Votes
Combine two stored procedure results
Hi mahima i also found same solution as define in ...Answered | 5 Replies | 17368 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
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 | 4561 Views | Created by sqlsantos - Wednesday, March 10, 2010 7:16 PM | Last reply by sqlsantos - Thursday, March 18, 2010 9:10 PM -
0 Votes
SQL populate table from stored procedure (temp no columns declares)
Pérez The Result of this stored procedure need to be stored into a table pleaseAnswered | 31 Replies | 9604 Views | Created by Borg239 - Thursday, October 13, 2011 9:02 PM | Last reply by Erland Sommarskog - Monday, October 17, 2011 8:25 PM -
0 Votes
Data Set not populating from stored procedure
I have noticed that you are calling another stored procedure EXEC dbo.Answered | 1 Replies | 2563 Views | Created by chrissy p82 - Wednesday, July 18, 2012 9:05 AM | Last reply by Syed Qazafi Anjum - Wednesday, July 18, 2012 11:42 AM -
1 Votes
Stored Procedure Result to CSV File
You can use bcp to export stored procedure results to flat file.Answered | 6 Replies | 31163 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 concatenate results from multiple Store procedures
But basically, if your stored procedures return dynamic number of columns, you would not be able to join the results from them unless you want to apply OpenQuery ...Answered | 9 Replies | 4066 Views | Created by cat_ca - Thursday, May 10, 2012 5:44 PM | Last reply by pratyaharam - Friday, May 11, 2012 12:21 PM -
0 Votes
how to return a table from a stored procedure in ssis
http://geekswithblogs.net/stun/archive/2009/03/05/mapping-stored-procedure-parameters-in-ssis-ole-db-source-editor.aspxAnswered | 6 Replies | 5721 Views | Created by priyanka sutrave - Wednesday, July 14, 2010 12:19 PM | Last reply by Manikandan S - Friday, July 16, 2010 12:43 PM - Items 1 to 20 of 1735381 Next ›
No announcements
