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 |
|
JJ297
Aged Yak Warrior
940 Posts |
 Posted - 2009-02-24 : 13:32:45
|
| If sysdate - App_Rcpdt is null then us DowrRcpdt? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-24 : 13:34:51
|
| [code]Coalesce(column,DowrRcpdt)[/code] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-24 : 13:34:57
|
| SET @Var=CASE WHEN DATEDIFF(dd,App_Rcpdt,GETDATE()) IS NULL THEN DowrRcpdt ENDwhere @var is variable to which value is to be assigned |
|
|
|
JJ297
Aged Yak Warrior
940 Posts |
Posted - 2009-02-24 : 13:50:48
|
| Thanks that worked! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-25 : 09:09:42
|
| welcome |
|
|
|
|
|
|
How would I write this?