insert #freebaltb EXEC GET_IVRSCRIPWISEBALANCE 888888888

i am executing this query  i m getting this kind of error

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name '#freebaltb'.

can u tell me...

Hi Thanks its Working

But  i have to create the #Temp table Structure externally what o/p used in the sp i have used.

its not create the temp table dynamically while...

Ok Is it Possible to Store The Output of Sp into Pernment table

Ok

But i Use This Command It shows Error

What command i use for this

exec <storedprocedure name> #temptablename

select * into #temptablename from <storedprocedure name>

both commands are failed to process...

Hi

Thanks for Reply

select * from yourtable where yourcolumn collate sql_latin1_general_cp1_ci_as = 'columnvalue'

i run the above query i get the following error

Incorrect syntax near 'collate'

Prakash