CREATE PROCEDURE USP_PROC_XXXX

(

@v_Order_No VARCHAR(5)

)

AS

BEGIN

 set  nocount on

 set  Transaction Isolation Level Serializable

 UPDATE OrdMain

 SET

 ListTotal = A.SumOfListItem

 FROM

 (SELECT Order_ID,SUM(ListEach) AS SumOfListItem

 FROM OrdItem

 GROUP BY Order_ID)

 AS A

 WHERE OrdMain.Order_ID = A.Order_ID

 -- AND OrdMain.Order_Num =...

I dont think for = there will be any problem.

DECLARE @C CHAR(1)

SET @C = '='

SELECT 1   as TAG,

  NULL  as PARENT,

  @C  as [RESPONSE!1!SAMPLE!ELEMENT]

FOR XML EXPLICIT  

Also for other characters we...

Dear Sergiy 

Thanks and it was a great help.I thaught of cursors because of the processes involved before Inserting to the first...

Sorry that I cross posted the doubt

Sorry for posting the query in the below link its written that  : In the present SQL Server 2000 world if we were to take the output of a FOR XML...