Skip to content

Instantly share code, notes, and snippets.

@diego-aslz

diego-aslz/QRFechamentoVendasCanceladas.sql

Created May 10, 2016 01:07
Show Gist options
  • Save diego-aslz/1be3e344f49e25d24b7d554b9418ff9a to your computer and use it in GitHub Desktop.
Save diego-aslz/1be3e344f49e25d24b7d554b9418ff9a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
QRFechamentoVendasCanceladas.sql
SELECT
MESA,
VALOR
FROM
VENDAS
WHERE
DT_CANCELAMENTO IS NOT NULL
AND
DATEADD(-3 HOUR TO DT_EMISSAO) BETWEEN :DT_INICIO
AND DATEADD(1 DAY TO :DT_FIM)
ORDER BY
ID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment