xp_sendmail using table variable as @query SQL Server 2000

Question

I am trying to send a resultset via email using xp_sendmail. I need to send the email when an earlier executed query has any results.

Got the query results into a table variable/temp table and then in xp_sendmail, using

Declare @table_var table(...)

..query execution..

EXEC master.dbo.xp_sendmail @recipients = '[email protected]', 
@query = 'select * from @table_var'

it gives error saying that

@table_var must be declared.

Even if I use temporary table, the message I get is

cannot reference object in tempdb database.

Any ideas on this?

Thanks in advance

Steve D · Accepted Answer · 2013-06-20 18:27:23Z

2

You'll need to use a real table for this. Try..

 If exists (select * from sys.tables where name = 'mytable')
      drop table mytable
    Create Table mytable table(...)


    ..query execution..

    EXEC master.dbo.xp_sendmail @recipients = '[email protected]', 
    @query = 'select * from mydatabase.dbo.mytable'

answered Jun 20, 2013 at 18:27

Steve D

5683 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

xp_sendmail using table variable as @query SQL Server 2000

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related