How can I eliminate repeated values in my query?
Posted on 2008-10-08
I have a query which works correctly until I add my case (CASE WHEN mv.end_date is null THEN 'Yes' ELSE 'No' END) Terminal_Group_Active) to the select list. mv.end_date is null when active and has an actual date when enddated. What I am finding is the active records are displaying twice , once with 'Yes' and once with 'No'. Any idea why?