I understand set based is always faster than a row by row operation. That was the reason for my initial post....I wanted to run dyn sql in a set...

Correct, it's a row by row problem.

I ended up writing a while loop (instead of the dreaded CURSOR) to go through the tblGroup rows.

There is a UI that builds the...

Thanks for letting me know it's not possible, I had a feeling that wasn't the case. In the end I just went ahead with a while loop solution.

Leo.Miller (12/22/2010)

---

I can't see much besides the insert...

Leo.Miller (12/22/2010)

---

I can't see much besides the insert...

Grant Fritchey (12/22/2010)

---

I might be missing something, but couldn't you just do a GROUP BY on the date with a count? Seems like that would be a lot easier than...

Sorry, I went back and added the attachments

Thanks Ken, this helps a lot. Actually thank all of you!

So Ken, I can append these Tlog backups to the Full backup...does that just create one file?

Also, is there...

Thanks for the replies Gents!

So I'll switch to Full recovery and just do nightly Full backups.

Then I'll do T Log backups every 15 mins....why not do Diff backups every 15...

Nope, it's set to Simple Recovery mode.

I realize I should probably switch to Full Recovery and do Diffs, T Log backups with Nightly full for the best/most complete recovery model.

Just...