Advertisement
Fhernd

CombinacionRegistros.sql

Jun 29th, 2016
1,147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.31 KB | None | 0 0
  1. SELECT BusinessEntityID,
  2.     GETDATE() QuotaDate,
  3.     SalesQuota
  4.     FROM Sales.SalesPerson
  5.     WHERE salesQuota > 0
  6. UNION ALL
  7. SELECT BusinessEntityID,
  8.     QuotaDate,
  9.     SalesQuota
  10.     FROM Sales.SalesPersonQuotaHistory
  11.     WHERE SalesQuota > 0
  12.     ORDER BY BusinessEntityID DESC,
  13.         SalesQuota DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement