How do i use order by when returning multiple rows as a string

See more:

C#

SQL

VS2010

Hi Coders, Im working on an enterprise application project, and need to order the ITEM_NAME by DAMAGE_REF_NO . im basically selecting and returning data from two views and want to bind them to an Infragistics Ultraweb Grid, please how do I Order by for the select @item, heres my whole stored Procedure:

create PROCEDURE [dbo].fetchDamageAssessmentForVoucherPrinting
   (
   @SUBSCRIBER_ID varchar(20),
   @DAMAGE_REF_NO  varchar(20)
   )

    AS
           declare @ITEM varchar(max)
           set @ITEM = ''

           SELECT @ITEM = ((SELECT   ',' + ITEM_NAME  FROM DAMAGE_DETAILS_VW   FOR XML PATH('') )  )



    SELECT * , @ITEM AS DESCRIPTION FROM  DAMAGE_ASSESSMENT_VW2 WHERE DAMAGE_REF_NO = @DAMAGE_REF_NO AND  SUBSCRIBER_ID = @SUBSCRIBER_ID


       RETURN