I have a table like this and in the code behind i have to show like tempname in a label and rundate in a dropdownlist i have to show like last 10 rundates in the drop down without duplicate name i mean i have to show unique tempname and associated rundates in DDL.how can i achieve this??I need a stored procedure for the same.I have a table like this and in the code beh