You can also use PsExec of sysinternals

the second Vasc Query should have been:

SELECT

 t1.HistoryDate,

 isnull(( SELECT MIN(HistoryDate )

  FROM dbo.tsgvw_JDEEmployeeHireRehireView

  WHERE DateType = 0 and HistoryDate>t1.HistoryDate and AddressNumber=t1.AddressNumber) ,@LimitDate)

 , t1.AddressNumber

FROM dbo.tsgvw_JDEEmployeeHireRehireView AS t1...

Not sure I followed all the way because DDL of ALL tables was not completed but here is a go: 

Update set   new_rate_210 =  case when T.PicNumber = 210 then T.rate_210...

... he can take his knowledge and ... WOW that was very brave! I have always liked your attitude, believe me

That's right! I will have to agree too!

Can you post some sample data and your expected results ?

Also I must point out that I don't like the convert option as it screws up the order by like this for numbers >> 12,1143, 2, 34

true! it's just...

You will need to be a bit more specific because distinct does just that!!

select distinct Fld from table

but without more specifics can't go further!

That's exactly why I didn't meant you to do it now I wouldn't like to see you suffering that much

I have been slow today ... Erm... like always

Yes you can but you will have to explicitly convert all those columns to the same datatype or separated columns

ps:I am definitely going to miss all of you and the nonsensical exchanges...

Can you resists those

I never meant you to do it immediately...

Je ne suis pas une personne très patiente ...my french is rusty too

BTW: What happened to your disguise threat? is it not going to happen ?

 .... - will you be giving him a piece of your mind if you meet him ?!?!

I don't even want to think about that