DECLARE @PID VARCHAR(10)
DECLARE @SQL NVARCHAR(MAX)
SELECT @PID= RIGHT(@PLANT,2)
SELECT @TABLENAME='GENERATEBARCODE'+@PID
SET @SQL='
SELECT BARCODEID,isnull(PRODUCTCODE,''NA'') AS PRODUCTCODE
,isnull(BATCHNO,''NA'') as BATCH_NO  FROM [dbo].'+@TABLENAME+' WHERE
 BARCODEID='+@BARCODEID
 EXEC(@SQL)