I created a smalldatetime column (PTL_StartDate_Dt) and  I tried running this update and did not work for me:

PTL_StartDate is a varchar column with values
01/15/2017
11/22/2016

Update...

Source is what it is... I can't change that.  I also don't see why the date column be updated in several parts..updating first the dd/mm/yyyy formats and then the dd.mm.yy...

This data was imported from another format.  Someone else will be taking care of it before importing it into SQL.  Thanks! I definitely learned something about the order of tables.

I'm not defining the order.  It's the natural order that the data is in.  When I do a Select * from table...and returns the order it is in.  When I...

If in a sproc I have multiple inserts, updates, deletes and user A calls the sproc and it is processing all the commands within the sproc and say there is...

Actually, just realized it is not at this stage where it is changed.  Data is fine.

I have to convert sql scripts to hadoop and it is case sensitive and having it all in upper case makes it easier. thanks

Wendel, thanks for the great information and advice.

thanks! I will look into persistent connections....

to edit it.... I know it's a large table, but our data is large. We may cut that down to 2 or 3 million. I don't...