Code:
Col1    Col2
   1       1
   1       2
   2       2
   3       3
Here's what I'm basically trying to do, from what I can see, it doesn't look like I can do 2 set statements, and don't really want 2 sql strings in my coding, can anyone tell me a way to achieve the below please :
Code:
Update Table1
Set Col1=A
Where Col2 = 2 AND col1=1
Set Col1=B 
Where Col2=2 and col1=2