@ChrisM@Work

Hi Chris,

Thanks for the feedback. The reasoning behind my long process is so I could put it in a view. Your script looks like it would...

rjoseph

To use this procedure one must set a few things up first.

1) Set the correct settings for:

----------------------------------------------------------------------------------------------------------------------------------------------------

----- Must be set based on individual needs

----------------------------------------------------------------------------------------------------------------------------------------------------

SET @BackupRoot = N'Q:' -- everything...

Thanks Charles for your comments. I'm not sure how that line of code got out of place. Thanks for posting that correction..

Yes i know this is a full...

Wayne,

This doesn't work on leap years.

Try these dates:

@DOB = '09/26/2011'

GetDate() = '09/25/2012'

mitch