Capture Exec SP result into TEMP table in SQL

Posted by Jeyjey under Sql Server on 1/14/2014 | Points: 10 | Views : 1704 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

I want to capture the executed stored procedure result into temp table.

select #temp into Exec SP name ??????????????

Could you please suggest anyone

Regards,
JJ

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Learningtorise on: 1/14/2014 [Member] Starter | Points: 25

0	You can't Do as Above. Do it as Follows: --Create Temporary Table For Example Mail Table CREATE TABLE #Mails ( [Subject] VARCHAR(1000), Body VARCHAR(8000), SentBy VARCHAR(100), SendTo VARCHAR(1000), CC VARCHAR(2000), BCC VARCHAR(2000) ) INSERT INTO #Mails ([Subject], Body, SentBy, SendTo, CC, BCC) EXEC [dbo].GetMailsByTcket @MyTicketNo http://hashtagakash.wordpress.com/ Jeyjey, if this helps please login to Mark As Answer. \| Alert Moderator

You can't Do as Above.

Do it as Follows:

--Create Temporary Table For Example Mail Table

CREATE TABLE #Mails (

	[Subject] VARCHAR(1000),

	Body VARCHAR(8000),

	SentBy VARCHAR(100),

	SendTo VARCHAR(1000),

	CC VARCHAR(2000),

	BCC VARCHAR(2000)

)



INSERT INTO #Mails ([Subject],	Body, SentBy, SendTo, CC, BCC)

 EXEC [dbo].GetMailsByTcket @MyTicketNo

http://hashtagakash.wordpress.com/

Jeyjey, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts