Any One Please Help me...

pls take it as challenges...

Regards,

Saravanan.D

Any One Please Help me...

Regards,

Saravanan.D

hi Lowell,

thanks 4 ur work... but i need the same xml file Generation....

Here i have Mentioned Required File Structure....

<Root>

<Node FirstName="Andrew" LastName="Fuller" Email="afuller@contoso.com" Phone="(205) 555 - 9898" Position="CEO" Branch="TopManagement"...

DECLARE @idoc int

DECLARE @doc xml

DECLARE @xmldata Table (FirstName varchar(110),

LastName varchar(210),

Email varchar(110),

Phone varchar(110),

Position...

I Got The Result as the Same File....

DECLARE @idoc int

DECLARE @doc xml

SET @doc ='<Root>

<Node FirstName="Andrew" LastName="Fuller" Email="afuller@contoso.com" Phone="(205) 555 - 9898" Position="CEO" Branch="TopManagement" Address="London, 120 Hanover Sq.">

<Node FirstName="Jeremy" LastName="Boather" Email="jboather@contoso.com"...

Hi Niels Christiansen,

Thank u ....

now i am using the XML Datatype

but i got a Result only one Row....

what about the other row..

How to get the Entire Record Set...

Please Help me...