如何将多行作为字符串返回时使用order by [英] How do i use order by when returning multiple rows as a string

问题描述

您好Coders，我正在处理企业应用程序项目，需要通过DAMAGE_REF_NO订购ITEM_NAME。我基本上从两个视图中选择并返回数据，并希望将它们绑定到Infragistics Ultraweb Grid，请如何为选择的@item排序，继承我的整个存储过程：

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

推荐答案

您可以使用

SELECT * FROM yourtablename ORDER BY columname [ASC, DESC]

。



希望它能帮助你到目前为止。





欢呼，

Marco Bertschi

.

Hope it helped you out so far.


cheers,
Marco Bertschi

这篇关于如何将多行作为字符串返回时使用order by的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！