Post reply

sorting on XML column

  • June 5, 2008 at 11:16 am

    #192010

    HI,

    I am working on a problem in which i have to apply sort on a table based on elements of an XML column.

    I have attached an image of the table. I want to sort on MemberNo in descending order.

    can any one please help me in this.

    thanks.

  • July 21, 2008 at 12:31 am

    #845556

    usman asghar (6/5/2008)

    HI,

    I am working on a problem in which i have to apply sort on a table based on elements of an XML column.

    I have attached an image of the table. I want to sort on MemberNo in descending order.

    can any one please help me in this.

    thanks.

    You could use the order by MemberNo desc ->Clause, to get the memberno in descending format!:)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply