Yes, u are great guys.

The problem was in @xmlja.nodes(N'/CallAccountingList/CallAccounting') t(c);

Thanks a lot 🙂

Here is original copy of xml file.

i want to insert into one table.

SELECT c.value(N'(Accounting/ChargedUserID)[1]', N'nvarchar(100)') AS ChargedUserID,

c.value(N'(Accounting/ChargedUserType)[1]', N'nvarchar(100)') AS ChargedUserType,

c.value(N'(Accounting/SubscriberName)[1]', N'nvarchar(100)') AS SubscriberName,

c.value(N'(Accounting/TrunkID)[1]', N'int') AS TrunkID,

c.value(N'(Accounting/Date)[1]', N'datetime') AS Date,

c.value(N'(Accounting/Time)[1]', N'datetime') AS Time,...

declare @tabela1 table (

ChargedUserID int,

ChargedUserType varchar(100),

SubscriberName varchar(100),

TrunkID int,

Date datetime,

Time datetime,

CallDuration datetime,

DialledNumber varchar(100),

DiallingMode varchar(100)

)

this is my table.

i want to insert those data to each column,

this xml file is to small,...