Ciao,
e' questa la sintassi:
CREATE PROCEDURE PGTOSQL
@SN AS VARCHAR(100)
AS
DECLARE @TABLE VARCHAR(100);
SET @TABLE = (SELECT Tablename FROM SERIALS WHERE SERIAL = @SN)
SET @PN =( SELECT pn FROM ' + @TABLE + ' WHERE SERIAL = @SN)
....
....
??
ecco l'errore:
Incorrect syntax near ' + @TABLE + '.
saluti
--------------------
Vincenzo PESANTE