Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Unikhath
Starting Member
12 Posts |
 Posted - 2008-09-09 : 18:09:44
|
| Hi,iwant to write an expression for conditions1. if name changes then update users2. if sponsorid changes , update users.how should I frame the expression in Conditional split task??Thanks |
|
|
favaz.farook@gmail.com
Starting Member
8 Posts |
Posted - 2008-09-15 : 09:49:16
|
| Changes to what SQL have no idea what do you mean by changeit has to be to some value, may be your Qs does not have enough explanations. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-15 : 12:32:49
|
| you're doing same operation (update users) for both conditions. so what i feel is you just want a exeute sql task which updates the table after checking the values of sponsorid and name and updating only if either is different from current value in table. |
|
|
|
|
|
|
Conditional split Expressions