Can u give your Table Structure & XML String u r passing to SP

Regards

You can get records if u have diff in No. of Fields / Diff in Data Type like this

Table 1

-------

Field1      Integer

Field2      Desc

Field3      Date

Table2

-------

Field1      Integer

Field2      Desc

Field4      Numeric(12,2)

SELECT Field1, Field2, Field3, 0...

Select TableA.Col1, 1 FromTable FROM TableA WHERE TableA.ID = 1;

UNION ALL

Select TableB.ColA, 2 AS FromTable FROM Table B WHERE TableB.ID = 2

U will get like this

Col1      FromTable

------------------

Record1         1

Record2          1

Record1          2

Record2           2

It might help u...

u can do this with OPENXML in SQL Server 2000

StrXml = "<master field1='value' field2='20.15'>

             <detail field1 ='value/>

             <detail field2 = 'value'/>

             </master>

CREATE PROCEDURE Usp_Test

         @pStrXml text

AS

DECLARE @IntDoc INT

SP_XML_PREPAREDOCUMENT @IntDOC OUTPUT, @pStrXml

Exapmle 1

1st Page

Select FName, LName From Member Table Order By FName

2nd Page - Same Query

3rd Page - Same Query

Now if Client say that Instead of Order By FName I want...

It worked

Thanks for your reply

Can you give me list of other special charatcers with its value ?

Waiting for your reply

Thanks

My Actual Problem is

I am passing XML Document To Stored Procedure which

use OPENXML Method to get data from XML & Update to database

It works fine, but when user enter...

It gives RTM

what it means

I want to know which SP is installed on my machine

if i put

Select @@Version

it comes like this

Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright...