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
SELECT * FROM yourtablename ORDER BY columname [ASC, DESC]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)