Duvida com Variavel

[michelgirardi 0]

Boa noite,

Estou tentando fazer um script com variáveis, e preciso definir qual a tabela através de uma variável.

Segue script, se alguém puder dar uma força, agradeço.

SET @serial := 'xxx';
SET @dtcp := '2016-10-28';
SET @icms := '99';
SET @dif := '-20';

SELECT QUANTIDADE INTO @qtd FROM vd201610 WHERE `SERIEECF` = @serial AND `DATA_CUPOM` = @dtcp AND `ICMS` = @icms AND `STATUS` <> 'C' ORDER BY `VLR_TOTAL` DESC LIMIT 1;
SELECT VLR_VENDA INTO @valorvenda FROM vd201610 WHERE `SERIEECF` = @serial AND `DATA_CUPOM` = @dtcp AND `ICMS` = @icms AND `STATUS` <> 'C' ORDER BY `VLR_TOTAL` DESC LIMIT 1;
SELECT VLR_TOTAL INTO @valortotal FROM vd201610 WHERE `SERIEECF` = @serial AND `DATA_CUPOM` = @dtcp AND `ICMS` = @icms AND `STATUS` <> 'C' ORDER BY `VLR_TOTAL` DESC LIMIT 1;
SELECT COO INTO @coo FROM vd201610 WHERE `SERIEECF` = @serial AND `DATA_CUPOM` = @dtcp AND `ICMS` = @icms AND `STATUS` <> 'C' ORDER BY `VLR_TOTAL` DESC LIMIT 1;
SELECT SEQUENCIAL INTO @seq FROM vd201610 WHERE `SERIEECF` = @serial AND `DATA_CUPOM` = @dtcp AND `ICMS` = @icms AND `STATUS` <> 'C' ORDER BY `VLR_TOTAL` DESC LIMIT 1;

SET @somatotal := @valortotal + @dif;
SET @novovenda := @somatotal / @qtd;

UPDATE vd201610 SET VLR_VENDA = @novovenda, VLR_TOTAL = @somatotal WHERE SERIEECF = @serial AND COO = @coo AND SEQUENCIAL = @seq AND DATA_CUPOM = @dtcp;

SELECT @qtd, @valorvenda, @valortotal, @coo, @seq, @somatotal, @novovenda;