Thanks for your post.

Yes...

dewit.john (8/27/2009)

---

I have used XML to insert multiple rows using a SP for years now. .... The code is not that complex. It usually just boils down to a set...

Max Minkov (8/25/2009)

---

Very insightful article!

INSERT

INTO [AddressBook]

([LastName], [FirstName],[Address])

SELECT

T.Item.query('./LastName').value('.', 'VARCHAR(25)') [LastName],

T.Item.query('./FirstName').value('.', 'VARCHAR(25)') [FirstName],

...

First of all thanks to every one for putting your valuable comment.

---

Jack Corbett (8/25/2009)

---

lafleurh (8/25/2009)

---

In the theoretical sense, it should not be necessary to insert multiple rows in one command...

balaji_92

---

Actually you could use XML to send multiple rows in SQL Server 2000 too. The only catch is if the database is run on Fibers instead of threads OpenXML would...

mohd.nizamuddin (8/18/2009)

---

Lee Forst:

I haven't tested for it that much records, but our application is working fine dealing with upto 400 - 500 records in an XML.

Will test for more records...

conradr (8/19/2009)

---

I'm Sorry.. I can see any benefit, ever, from sending muliple rows of data to a database. The mechansimsof transactional behaviour on the client side or destaging mechanisms where...

I am not confirmed that you are asking about puting the WHERE clause in SP.

WHERE T.Item.value('@Salary', 'INT') < 10

This will filter records whose...

First of all thanks for your valuable comment with different approach.

R.P.Rozema, sql :

Actually in my scenario we can access database only by SP. So we must not use any...

Thanks Daniel,

Actually this is based on SQL...

Hi Rajesh,

You should JOIN the tables instead of using SubQuery.

Moreover, you can try deleting rows in batch as below

SET ROWCOUNT somenumber -- this could be 100000 or any number...

Hi,

Instead of SubQuery, you should write query using JOIN.

Secondly, you may try to delete rows in batch of records like 10000 records and then commit. This will not take much...

Ok,

Even I didn't see the code here at the forum in detail. Because I used to review the code in its specific IDE (VS IDE in this case). So, I...

Hi Sanjeet,

Could you please provide the definition of class "CLIENT_FIELDS", it would be easier to simulate your problem.

I think you are using SQL SERVER 2008.

Please suggest the ASP.NET version.

You said...

We are getting 20 working days leave + 12 holidays (not falling on weekend) + 6 Medical Leaves. What else we require.

Only job security.