Advertisement
Guest User

Untitled

a guest
Oct 21st, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.31 KB | None | 0 0
  1. USE History
  2.  
  3. SELECT
  4.   Month(EntryDate)       AS [Month],
  5.   year(EntryDate)        AS [Year],
  6.   count(NSCCPassThru_TC) AS [Total Fills],
  7.   Sum(NSCCPassThru_TC)   AS [Charged by LEK]
  8. FROM trAVA_m_all
  9. WHERE NSCCPassThru_TC = 0 AND (Comment IS NULL OR Len(Comment) < 1)
  10. GROUP BY Month(EntryDate), YEAR(EntryDate)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement