Great feedback. Thank you everyone.

I do not have a space issue. I simply wanted to reduce the log file space used because the server is virtualized...

I don't know that the contributors so far have looked at this from a perspective other than as a DBA.

As a DBA I like the idea of being...

Locate hornets' nest, insert stick.

I will have to assume that either this is a simple typo or an ingenious method to rile the community.

Since we are all SQL people here...

Interesting, John. I'm always looking for ways to optimize queries. I appreciate your contribution.

Emote :BeatingHeadAgainstDesk:

http://www.learntoread.com/

Thank you for your reply, Howard. I had read that document but I was hoping there was a work-around.

From my understanding, I cannot use Dynamic SQL because it cannot...

No my desire is to create an enterprise level function where I can pass a datepart and a datetime and have it return the datetime rounded to the datepart.

Example:

ROUNDDATE(d,'03/18/2011 10:50:42')...