Ok, tested and works perfectly, thanks for all the help.

The wierd thing is that it works fine as a standalone T-SQL command in Management Studio as

ALTER TABLE extract ADD NewLastLoginDate...

Ideally Id love to store the date time as it is, and get the MI guys to convert the data in their queries...but I am where I am.

In the solution...

GilaMonster (8/17/2010)

---

You can, it's a little more complex that way as you need to know the distribution of the data. I'd typically do it like this. (not tested!)

DECLARE @Done Bit;

Set...

The recovery model is SIMPLE

would you batch it with a WHERE...

USE DBSUPPORT

UPDATE extract

SET NewLastLoginDate = convert(datetime, lastlogindate, 103) WHERE LastLoginDate < 2010

GO

USE DBSUPPORT

UPDATE extract

SET NewLastLoginDate = convert(datetime, lastlogindate,...