If you are using Sql server 2012, you can try IIF. Read:
http://msdn.microsoft.com/en-us/library/hh213574.aspx
Or you can use a cursor and loop to update the rows one by one. Read:
http://www.mssqltips.com/sqlservertip/1599/sql-server-cursor-example/
Many Thanks & Best Regards, Hua Min
No comments:
Post a Comment