Jorge Serres (4/18/2012)

---

Was testing it and it runs gr8! However, it'd be good if could be extended to run for multiple Databases within the given server or even servers.

So, I'd...

I overlooked that it is a STRING comparison and got the answer wrong.:-) (though writer had intention to show datetime comparison)

I updated the code as follows and executed:

DECLARE @DATE DATETIME

SET...

Thanks to all who posted comments. I myself got to learn more by reading all the comments.

charlietuna (10/23/2011)

---

The solution seems a bit opaque. Something like this is (to me) much more straightforward for the next person who has to read it:

update #t

set col1 = case col1...

Thanks L' Eomot Inversé for pointing it out. I overlook this while putting the explanation.

Thanks Hugo!

Your comments help to learn more.

Thanks Hugo! your explaination is very helpful. also thanks for pointing out the misleading pharse. in future i can now be more careful for writing any stuff on SSC

Hi,

I have uploaded whole code on the site. I don't know why your are not able to run the code.

Can you post the code your are trying to run in...

Hi,

Can you post the staments that your are trying to execute? I will be able to help you in better manner after viewing those sql statements.