• By the way, please don't use date literals like this:

    'MM/DD/YY'

    This might will not work on system which use other language settings (or datetime settings) than english.

    Please always use the ISO literals like this instead:

    'YYYYMMDD'

    They do work. Always: http://www.karaszi.com/SQLServer/info_datetime.asp