quote:

---

How to schedule a Daily Deletion of those rows which are in the tables already (Each day 6 Days must be Deleted and 1 kept)

---

quote:

---

Originally posted by khtan

You can use DTS or BCP or BULK INSERT to import data into the database and schedule it using SQL Agent

---

KH

---

quote:

---

Originally posted by chiragkhabaria

quote:

---

How to schedule a Daily Deletion of those rows which are in the tables already (Each day 6 Days must be Deleted and 1 kept)

---

Wirte the trigger for it, so that it doesnt allow the duplicate rows to be inserted into the database.

or have some contraints on the table which may prevent from uploading the duplicates rows.

or you can schedule the Job for doing this. you can find the query for it on the following link

http://sqlteam.com/forums/topic.asp?TOPIC_ID=6256


Chirag

http://chirikworld.blogspot.com/

---

quote:

---

Originally posted by darrendorlando

http://com-hpdevelopersolutions-2s.wwwa.com/members/remoteLoginCheck.cfm?id=MTMzMDAsYmxhY2tmaW4sL21lbWJlcnMvZXF1aXBtZW50L2luZGV4LmNmbQ_


This works for me and is way more efficient! Give'r a try, but remember to back up first and test the results to make sure you what you are expecting happens!


DELETE FROM [Table with Duplicates]
WHERE [Primary Key Field] IN
(
SELECT a.[Primary Key Field]
FROM [Table with Duplicates] a,
[Table with Duplicates] b

WHERE a.[Primary Key Field]!= b.[Primary Key Field] -- i.e. Userkey
AND a.[Value to check]= b.[Value to Check] -- i.e. Lastname
AND a.[Second Value to Check] = b.[Second Value to Check] -- i.e. Firstname
AND a.[Primary Key Field] < b.[Primary Key Field] -- i.e. Userkey
)


dd
ddorlando@gmail.com

---