Writing code is my weakness so, please bare with me as I give too much info & an attachment. I'm pulling duplicate records from a field that has multiple member types {Member_Types.MEMBER_TYPE} & I need to adjust the report. What I want to do is pull only the duplicate records that contain a duplicate + a valid member type.
1.For example 2 records meet my duplicate criteria & have a member type of GEN & NM - I want to show on the report.
2.But if 2 records meet my duplicate criteria & have a member type of NM & NM - I don't want it to show on the report.
The weird part is it looks like the report is running an SP:{CALL "iMIS"."dbo"."AACAP_GET_DUPLICATE_RECS_SP";1}
Below is the duplicate match key we're using:
UPPER(SUBSTRING(Name.ZIP,1,5) + (CASE WHEN Name.LAST_NAME<>'' THEN (SUBSTRING(Name.LAST_NAME,1,4) + SUBSTRING(Name.FIRST_NAME,1,1)) ELSE SUBSTRING(Name.COMPANY,1,5) END))
I hope I was able to explain that correctly? Any help would be appreciated.
* The Best Reasons to Target Windows 8
Learn some of the best reasons why you should seriously consider bringing your Android mobile development expertise to bear on the Windows 8 platform.