I created this query against a sharepoint 2010 list. I want to select distinct year. not just year. Can you tell me how can I get a list of distinct year in this type of query? MSDNStudent Knows not much!

Hi, Please refer point no. 77 from http://blogs.msdn.com/b/sqlforum/archive/2011/06/10/sql-server-faqs-ebook-with-database-engine-ssrs-ssis-ssas-.aspx Regards, Asim Bagwan Kindly mark the replies as Answers if they help!