Hi,

I have following stored procedure:
SELECT
...
FROM databasename@servername:tablename
WHERE
...

In my case I need to pass servername as parameter and use that parameter in FROM statement.
Is it possible? If it is then what should be a syntax of FROM statement?

Thanks,
Victor

You are talking dynamic SQL - which is not supported. There are some work-arounds, but none are elegant.

Use prepare sql of ESQL and 4GL