Advertisement
Guest User

Untitled

a guest
Jun 25th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. select sh.CurrencyRateID, cr.ToCurrencyCode,
  2. sum(TotalDue) as [cantidad facturada], month(OrderDate) as mes
  3. from sales.SalesOrderHeader sh
  4. join sales.CurrencyRate cr
  5. on sh.CurrencyRateID=cr.CurrencyRateID
  6. group by sh.CurrencyRateID, cr.ToCurrencyCode, month(OrderDate)
  7. order by sh.CurrencyRateID asc, 2 desc, 4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement