SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
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  

Yak Posting Veteran

56 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.


Most Valuable Yak

15731 Posts

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

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.03 seconds. Powered By: Snitz Forums 2000