Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- *
- FROM (
- SELECT
- groupId
- ,agentId
- ,RIGHT(impPackageCode, 4) as [Year]
- FROM
- att_schema.att_nmfData
- WHERE agentId IS NOT NULL
- AND ISNUMERIC(RIGHT(impPackageCode, 4)) = 1
- AND CONVERT(INT, RIGHT(impPackageCode, 4)) IN ( 2011, 2010 )
- ) x WHERE [Year] = 2011
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement