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 |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2012-01-16 : 10:16:18
|
| Good afetrnon,i stumbled with this senetence but i cant get it at all, its just comparing 2 NULL VALUES? (but how can a null value can be greather (>) than another NULL value?) AND (ISNULL (TEMP.FEC_REAL,''19000101'') > ISNULL (ACA_INCIDENCIA.FEC_REAL,''19000101'') OR ISNULL (TEMP.FEC_HISTORICO,''19000101'') > ISNULL(ACA_INCIDENCIA.FEC_HISTORICO,''19000101'') Thanks for your help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-16 : 10:24:59
|
| [code]...AND (TEMP.FEC_REAL > ACA_INCIDENCIA.FEC_REAL OR (TEMP.FEC_REAL IS NULL AND ACA_INCIDENCIA.FEC_REAL IS NULL))OR (TEMP.FEC_HISTORICO > ACA_INCIDENCIA.FEC_HISTORICO OR (TEMP.FEC_HISTORICO IS NULL AND ACA_INCIDENCIA.FEC_HISTORICO IS NULL))..[/code]------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Understanding tgis ISNULL sentence