• aay (8/18/2009)


    How can I use where clause ??

    I am not confirmed that you are asking about puting the WHERE clause in SP.

    WHERE T.Item.value('@Salary', 'INT') < 10

    This will filter records whose salary < 10.