thank's for the answers, i tried updated_date_time column also there was in the table and that's okay. But i wished that may be there was a word for the...

sory,

the xml data do not seem, i send it with attachement

Thank you very much RBarry, you are great, i was just working about the give you a sample table.

your query worked good on the sample table and i'll trie it...

no it's working wrong,

Delete From FATHAR

Where EXISTS( Select * from FATHAR T2

Where FATHAR.FATHARREFNO = T2.FATHARREFNO

...

thank you again, i think it's working i'll trie a few on it

yes i tried, but "select * from Invoicetable T " is incorrect syntax

oopps wrong forum, sory again

thank's for your helps but they did not work because of i think my server is sql 2000

thank's for help saurabh.k.singh

you are great

thank's a lot Joe, i tought in morning to save the transactions with different names and after all saved ,commit or rollback from .net and afternoon i...

this will use for save a bill by a VS .net program

there are two tables:

1)BILLTABLE

columns:date,CustomerName,BillNumber,BillCost

2)BILLRECORDSTABLE

columns:

BillNumber,RecordNo,ProductName,Quantity,ProductCost,TotalCost

the first Stored Procedure Sp_Bill_Insert is inserting Bill Header data to the BILLTABLE by...

Thanks a lot

thanks a lot noeld, you swithed on a lamp in my mind.