Guest User

Untitled

a guest
Mar 22nd, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. SELECT COUNT(DISTINCT d.PONum) AS POCount,
  2. ISNULL(SUM(d.DocExtCost), 0) AS POValue,
  3. CASE v.Buyer_c
  4. WHEN 'Person5' THEN 'Person4'
  5. ELSE v.Buyer_c
  6. END AS BuyerID
  7.  
  8. FROM [Dbo].PODetail AS d
  9.  
  10. INNER JOIN [Dbo].Vendor AS v
  11. ON (d.Company = v.Company AND
  12. d.VendorNum = v.VendorNum)
  13.  
  14. WHERE v.Buyer_c IN ('Person1', 'Person2', 'Person3', 'Person4', 'Person5')
  15.  
  16. GROUP BY CASE v.Buyer_c
  17. WHEN 'Person5' THEN 'Person4'
  18. ELSE v.Buyer_c
  19. END
  20.  
  21. ORDER BY v.Buyer_c <-- This order by doesn't work
  22.  
  23. Column "Dbo.Vendor.Buyer_c" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.*
  24.  
  25. GROUP BY CASE v.Buyer_c
  26. WHEN 'Person5' THEN 'Person4'
  27. ELSE v.Buyer_c
  28. END,
  29. v.Buyer_c
Add Comment
Please, Sign In to add comment