Just finishing off something and made an adjustment regarding global variables - but in a
execute sql statement i cannot seem to be able to use the global variable in an SET statement

Is this true - can it only be used directly in a where statement and not as part of a variable

\Michael Vardinghus

to set a vairable value in T-SQL use
SELECT @@Varaible = <Value>


"Michael Vardinghus" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks Mark

But it wasn't just a variable .. it was a global parameter in a dts package
that I had to throw into a variable in an execute sql statement. Figured it
out - however - it seems like
the sql statement can't do this - but by making a stored procedure instead I
was able to throw the global variable down and use it in a set variable
statement.

\Michael V.

Mark Jones <mjones (AT) messagelabs (DOT) com> wrote