AJ0718
asked on
SQL - T-SQL Syntax Question
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.
I think this should be doable but I am totally stuck on syntax. Any helpful experts want to give me a start? Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER