>Hi all:
>
>Is it possible that we can execute a procedure(sp_amount) in a string format? Please see below.
>
>
>declare @lerror char(50), @lcserver char(20), @lcdbname char(65), @lcsqlcmd char(1000)
>select @lcserver = "[ej\jan]"
>select @lcdbname = 'nsc'
>
>select lcsqlcmd = "@lcserver.@lcdbname.dbo.sp_amount @cValue = 1, @error = @lerror output"
>execute(lcsqlcmd)
>
>
>however it gives me an error on it.
>
>Hoping for your quick response. Thanks
>
>Jan
select lcsqlcmd = @lcserver + '.' + @lcdbname + '.dbo.sp_amount @cValue = 1, @error = @lerror output'
execute(lcsqlcmd)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
