Temp table:- Its urgent

Posted Date: 04 Mar 2008 Posted By:: Johan Member Level: Gold Member Rank: 1197 Points: 2 Responses: 2

hii all,

i hav a stored procedure with in that i have a temporary table.
i want to access that temporary table valuse from another procedure.
How can i do this.. plz help me ..its urgent..
Thanx in advance

Responses

#197831 Author: jayapragash.D Member Level: Gold Member Rank: 0 Date: 04/Mar/2008 Rating: Points: 2
hai Create #Temtable(<Column name 1 datatype>,<Column name 2 datatype>) insert into #Temtable select (<Column name 1 datatype>,<Column name 2 datatype> from ur Table Regards D.Jayapragash

#197833 Author: Nitin Srivastava Member Level: Silver Member Rank: 0 Date: 04/Mar/2008 Rating: Points: 2
Hi, This is not possible for a simple temp table. Use global temp table.

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Buffer size Error , when using DTS FOr memo field for SQL to Text Export
	Previous : Temp table:- Its urgent
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription