SELECT programme_main_id
FROM dbo.para_sub_details
GROUP BY programme_main_id
HAVING (COUNT(programme_main_id) > 1)
This uses a simple SQL statement which identifies those entries which have dupliate programme_main_id
Paul
SELECT programme_main_id
FROM dbo.para_sub_details
GROUP BY programme_main_id
HAVING (COUNT(programme_main_id) > 1)
This uses a simple SQL statement which identifies those entries which have dupliate programme_main_id
Paul