SQL - T-SQL Syntax Question
Posted on 2014-03-18
I have a small table with LocationID and Year fields which I would like to manipulate into a view that can be used in a sproc to bind this and additional data to an asp.net control. For each LocationID I am trying to concatenate the associated years (ordered DESC) into a comma-separated string field which will in turn be bound to my tooltip.
I think this should be doable but I am totally stuck on syntax. Any helpful experts want to give me a start? Thanks.