Now that makes total sense. Here is some code:

create Table #temp1

(

id int,

Rno int,

sno int

)

insert into #temp1 values(10,125,32)

insert into #temp1 values(20,145,32)

insert into #temp1 values(10,125,32)

insert into #temp1 values(30,125,32)

insert into...

Steve Jones - Editor (12/16/2008)

---

I'm happy to entertain moderator nominations. It helps to have others that can move threads if they're in the wrong spot. I hate to have people...

I'm sorry, but I'm confused as to what you want as a result set based on the sample data. Your verbal discription is confusing, and your answer to Barry...

david.c.holley (12/16/2008)

---

Been busy...

For the record, the discussion groups that I have been apart of do not have stringent rules as to what needs to be included and what does not....

He's back..... But looks like he doesn't like our "requirements" for getting help and

I'll be looking for a forum a bit more consistent with my prior experience so as...

bitbucket (12/16/2008)

---

Jeff

Jeff should I be proud of this nomination and...

Took your advice and deleted the entire post.

Jeff Moden (12/16/2008)

---

Heh... gotta think "pork...

Instead of trying to describe in words what the result set should be, show us what the result set should be. You don't need to know how to write...

Was that good enough over there? I hate it when I click on a link in an email notification and it dies.

Jeff Moden (12/16/2008)

---

Lynn Pettis (12/16/2008)

---

Well, looks like Jeff's twit logged on today, but I haven't heard squat regarding the code I provided. I guess the first pork chop Jeff...

Okay, so based on those simple examples, what have you come up with and what problems have you encountered?

Amol.Naik (12/16/2008)

---

The Transaction log backup is assumed to be running every 10 or 15 minutes in a Production environment. BACKUP LOG command could be used in scenarios where the transaction...

Maybe. That's the first thing I'd try, but then I'm the type to jump in and try things.

Amol.Naik (12/16/2008)

---

Firstly the deletes on Production has to be happen off-hours, this will avoid any blocking.

Secondly the deletes have to be in batches, say in a batch of 3000 to...