The problem I am having is getting the syntax right so I can pass a
parameter along with the procedure call.
I have tried this:
SELECT @year = 2002
SELECT @remoteProc = "<server>.<database>.dbo.<procedure> @parm=" +
CONVERT(CHAR(4),@year)
EXEC @procStatus = @remoteProc
. . . and I receive the message "<procedure> @year=2002 not a valid
identifier"
I have tried various formats for the procedure parameter, using the
@year= and passing it without. How do I pass a parameter in an
execute immediate remote procedure call?
Sybase documentation is very sparse in this area. Thanks for any help
you can provide.
--Greg