SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Query Help
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

IK1972
Starting Member

47 Posts

Posted - 02/28/2013 :  16:57:08  Show Profile

I have one table with 5 columns

Comments, Table1, Table2, Table3, Table4
null, A, B, C, D
null, F, B, A, G
null, A, S, B, D
null, E, A, J, S

now i want to update like that

update t
set Comments = Comments + case when t.Table1 = 'A' then 'Table1--'
when t.Table2 = 'B' then 'Table2--'
from #temp

After update My Expected Result is

Comments, Table1, Table2, Table3, Table4
Table1--Table2, A, B, C, D
Table2, F, B, A, G
Table1, A, S, B, D
null, E, A, J, S

Please not suggest to check both column in same case as here I mention very simple condition actualy I have table with 150 columns and with different check and I want to mention comments when cretira match.

Thanks


robvolk
Most Valuable Yak

USA
15655 Posts

Posted - 02/28/2013 :  17:43:28  Show Profile  Visit robvolk's Homepage
Dupe:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=183369
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000