String concat order problem when grouping
Posted on 2009-05-15
I have written a CLR string concat function, the problem is when using it in my sql statement the order of the items that are concatenated seems to be dependant on the column itself.
How to be explicit on the order ?
My current sql
SELECT cast(dbo.StringConcat(cast(description as varchar)) as varchar(max)) AS [description],
[vw_ECS_OM_JobNotes_Job].[reference] AS [reference] FROM [vw_ECS_OM_JobNotes_Job]
GROUP BY [vw_ECS_OM_JobNotes_Job].[reference]
results in the actual description being alphabetically appended to the aggregate result, however i have another column called sequence that i need to be the order...
I tried ordering inside the view but this doesnt work either ?