Thanks! Looks like I had the correct code in the first place; I just tested it incorrectly.

I do like the new structure that you proposed, so I'm going to...

Not sure. I inherited this package. I suppose I can just change it to INT in the destination table.

HOWEVER, when I try to import this file via the...

Got it! By removing the "STATUS" reference in the GROUP BY I was able to get it to work. Thanks for the help everyone!!!

Here is the data...

Thanks!!!

Here is the table structure; working on some data.

kind of what I did here...when I run this query, it drops one of the counts, so I'm left with 1...it seems to be skipping over one of them.

21090ERT-LCu108876ExecutiveLetter011

SELECT

DRV.DATE_KEY,

DRV.REPORTING_TEAM,

DRV.UID,

DRV.REG_EXEC,

DRV.CONTACT_TYPE,

SUM(CASE...