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 |
|
igator210
Starting Member
5 Posts |
 Posted - 2012-05-14 : 11:28:21
|
| I have an Excel formula....if(A<B,A,B)For TSQL, would that be written...CASE WHEN (A<B) THEN (A) ELSE (B) ENDNate |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-14 : 11:35:45
|
| Yes. The parentheses are not strictly required either, unless you have compound conditions that mix AND and OR. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Picking 1 of 2 numbers