nasy_mcs (1/4/2014)
Hi, can anyone help here?Thanks!!
Add a WHERE clause that limits prd_cd to only those values that you test for in the CASE statements and see if that helps return the answer you're looking for.
--Jeff Moden
Change is inevitable... Change for the better is not.