Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select sh.CurrencyRateID, cr.ToCurrencyCode,
- sum(TotalDue) as [cantidad facturada], month(OrderDate) as mes
- from sales.SalesOrderHeader sh
- join sales.CurrencyRate cr
- on sh.CurrencyRateID=cr.CurrencyRateID
- group by sh.CurrencyRateID, cr.ToCurrencyCode, month(OrderDate)
- order by sh.CurrencyRateID asc, 2 desc, 4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement