I think XML Data Type cannot accept so many line. What a terrible

yep. May be it is truncated

My application is ASP.NET. Here the code,

XDocument doc = new XDocument(

...

Yes Mr Dwain. This is not homework or something. This is what I'm facing on

Till now, I did not see the supportive answer from expert

Sir,

It's work. Your guidance is an inspiration for me

Mark Fitzgerald-331224 (4/14/2012)

---

The query required is listed below. I have included a query to show the result set but this is not required in the final code.

declare @tApplyProgram table...

tq skcadavre for your effort

Sir Waynes,

Your query working awesome. tq sir

My mistake. My table as following,

declare @tMenuCollection table(idx int,parentID int,menuNme varchar(50),navigateUrl varchar(50));

insert into @tMenuCollection values(1,0,'Bayar Zakat','void(0)');

insert into @tMenuCollection values(2,0,'Amil','void(0)');

insert into @tMenuCollection values(3,0,'Kira Zakat & Simpan','void(0)');

insert into @tMenuCollection values(4,3,'Tambah','void(0)');

insert into @tMenuCollection...

i want to say to thank you for all answer given

Sir,

Did we've a choice to setup another technical things instead of Linked Server?

I'm heard, Linked Server have a potential to interrupt a performance

Hi Sir,

Without Linked Server is setup, and

Based on article on http://msdn.microsoft.com/en-us/library/ms188386(v=SQL.90).aspx

I was run T/SQL as follow,

SET XACT_ABORT ON

BEGIN DISTRIBUTED TRANSACTION;

-- Insert

insert into tPurchaseOrder values('1926','Purchase Order');

-- Insert

insert into [MAFC-SVR1\NAV1].st3db.dbo.tDeliveryNote(no,remark)...

Hi Sir,

To using this statement, no need to setup Linked Server first right?

tq sir

Hi sir,

With your guidance, now i know how to insert into t6 and t7.

But if my resultset as follow,

RID ...

tq sir.