quote:

---

Originally posted by sergeant_time

I am recieving "The Multi-part identifier could ot be bound whe I try to rune my query.

SELECT CASE WHEN INS_PRODUCT = 'HB' THEN 'HBCC' WHEN INS_PRODUCT = 'FP' THEN 'FPCC' WHEN INS_PRODUCT = 'PS' THEN 'PCCC' ELSE CAST(INS_PRODUCT AS varchar(2)) END AS Split
FROM (SELECT CASE WHEN SR_SUB_AREA = 'Complaint' OR
SR_SUB_AREA = 'Compliment' OR
SR_SUB_AREA = 'Crisis Call' OR
SR_SUB_AREA = 'Death Notification' OR
SR_SUB_AREA = 'Eligibility' OR
SR_SUB_AREA = 'Enrollment' OR
SR_SUB_AREA = 'Facility' OR
SR_SUB_AREA = 'Fee Basis' OR
SR_SUB_AREA = 'General' OR
SR_SUB_AREA = 'Hardship' OR
SR_SUB_AREA = 'HealthierUS Vet' OR
SR_SUB_AREA = 'HEC' OR
SR_SUB_AREA = 'IRIS' OR
SR_SUB_AREA = 'Medicare' OR
SR_SUB_AREA = 'Medicare Part D' OR
SR_SUB_AREA = 'NARA' OR
SR_SUB_AREA = 'NCOA' OR
SR_SUB_AREA = 'NON VA Questions' OR
SR_SUB_AREA = 'Pharmacy' OR
SR_SUB_AREA = 'Privacy Mailing' OR
SR_SUB_AREA = 'Project Hero' OR
SR_SUB_AREA = 'REgional Office' OR
SR_SUB_AREA = 'Repayment Plan' OR
SR_SUB_AREA = 'Transcription' OR
SR_SUB_AREA = 'Transferred Calls' OR
SR_SUB_AREA = 'VA Survey-HEalth C' OR
SR_SUB_AREA = 'VIC General Question' OR
SR_SUB_AREA = 'Waiver' OR
R_SUB_AREA IS NULL THEN 'Other' ELSE SR_SUB_AREA END AS SubArea, SR_SUB_AREA, INS_PRODUCT, SR_NUM
FROM S_SRV_REQ) AS a
WHERE (S_SRV_REQ.SR_NUM IS NOT NULL) AND (S_SRV_REQ.SR_SUB_AREA IS NOT NULL) AND (S_SRV_REQ.INS_PRODUCT IS NOT NULL)
GROUP BY S_SRV_REQ.INS_PRODUCT, S_SRV_REQ.SR_SUB_AREA

---

WHERE (a.SR_NUM IS NOT NULL) AND (a.SR_SUB_AREA IS NOT NULL) AND (a.INS_PRODUCT IS NOT NULL)
GROUP BY a.INS_PRODUCT, a.SR_SUB_AREA