Hello all. I have been researching this for quite some time, however, cannot seem to find anything that pertains to my specific question. I need to write a subquery within the following to only pull records where the account number (customeraccountnumber) appears more than once based on the attached query criteria sample. Any and all assistance/feeback is greatly appreciated!
FROM [Filteredcustomerinteraction] i
where name not like '%no call%'
and i.name not like '%ASA%'
and i.name not like '%Wrong department%'
and i.contacttypeidname = 'Call - Inbound'
and i.primaryreasondetailname not like '%transferred call%'
and i.createdon >= '03/21/2011'
and i.createdon < '03/23/2011'
and i.siteid = '14'