Thanks for your Reply.

I have modified the SQL query and the below SQL query done what i need exactly.

DECLARE @MyCursor CURSOR

DECLARE @txtValue varchar(MAX)

BEGIN

SET @MyCursor = CURSOR...

Still I am getting the same error as below

Msg 512, Level 16, State 1, Line 6

Subquery returned more than 1 value. This is not permitted when the subquery follows =,...

Thanks for your reply.

The above solution will extract Cancellation date from Static XML. But I need to retrieve Cancellation date from Table which contains more than one row.So I have...