Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare @data DATETIME = '17-06-2018' /*Colocar data aqui*/
- select sum(A.preco * m.quantidade)
- from movimentos m join
- Artigo a
- on m.idArtigo = a.idArtigo
- where m.data <= @data and m.data > dateAdd("d", -8, @data) and m.origem = 'loja'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement