SHARE
TWEET

Untitled

a guest Aug 20th, 2019 76 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. a.[Region],
  2. a.[Country],
  3. a.[site],
  4. a.[Account Type],
  5. q.[month],
  6. q.[account],
  7. q.[metric],
  8. q.[Goal],
  9. q.[Unit],
  10. q.[Actual],
  11. q.[Waived],
  12. q.[Weight],
  13. q.[Achieved],
  14. q.[SubmittedDateTime]
  15.  
  16. from [accountTable] a right join [scoreTable] q, (select
  17. max(q.[SubmittedDateTime]) as max_date
  18. group by q.[Month])  on a.[account] = q.[account]
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top