I retrieved all the records from database, and there are lots of duplicates due to pushing all the records into drop down list.

Code:

Code:
    SQL = "SELECT * FROM insite.holiday where calendar_Type= '" &sCalendarType& "' order by date_holiday"
Reason for not using distinct is due to other fields are required from this query.

Before:

>2013,2013,2013 ,2013,........