Hi,
I am getting error when I run the following statement




declare @a nvarchar(255)
select @a = tblname from logtbl where tblname like 'orders%'
and logtbl.logdate > getdate() - .5

update @a
set @a.log_id = l.log_id
from @a , logtbl l
where l.logdate > getdate() - .5
l.tblname like 'orders%'


Server: Msg 137, Level 15, State 2
Must declare the variable '@a'.

Plz.help

Steve

You cannot use variables like this. If you want to do this then consider
using

1. Dynamic SQL

http://www.sommarskog.se/

2. DTS and the object model

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Steve" <Steve (AT) discussions (DOT) microsoft.com> wrote