Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE History
- SELECT
- Month(EntryDate) AS [Month],
- year(EntryDate) AS [Year],
- count(NSCCPassThru_TC) AS [Total Fills],
- Sum(NSCCPassThru_TC) AS [Charged by LEK]
- FROM trAVA_m_all
- WHERE NSCCPassThru_TC = 0 AND (Comment IS NULL OR Len(Comment) < 1)
- GROUP BY Month(EntryDate), YEAR(EntryDate)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement