Thanks I have updated and re-submitted the script.

Thanks Jeff. I will check the useful links for the Tally table. I have never used it before. Thanks again for enlightening me that these two methods will be slow...

Thanks Jeff I will have a look at it. I initially assumed it wasnt using a cursor. I havent seen it before though.

Thanks very much but I dont have sql 2000. I am using 2005 and 2008.

I know about the one from ssms but whether it saves time depends on what you are doing and where you are and am not sure if that from ssms...

You are right and this will make it more faster than the solution I provided with the cursor.

Thanks

Thanks for the comment. If you copy the script and execute in sqlserver2008 AdventureWorks, you will immediately get results. I will however put sample results in my future post. Thanks....

Joe you can also try this:

DECLARE @table TABLE (MyDate Varchar(25))

insert @table

SELECT '3/28/2012'

SELECT CONVERT(VARCHAR(25),CONVERT(DATETIME,MyDate),112) FROM @table

Thanks

Benson Sibanda