Conditional Calculation in SELECT quert (SQL SERVER 2005)

[katrina11]

I know how to do it in SAS but have no idea how to implement this conditional calculation in SQL Server 2005

if LOSp=. then LOSp=0;
HospDischDate=intnx('DtDay', Admitdt, LOSp)

The thing is that I would like to calculate HospDischDate=AdmitDt + LOSP in the body of Select Query:

select
field1
,field2
,??????
into desiredTable
FROM myTable

LOS is a length of Stay in hospital(in days) while
two other fields are dates . For ex. Admitdt looks like 2010-11-16 00:00:00

How can I implement the SELECT query with calculation?

Any help would greatly appreciated

Katrin

 

[markros]

Look at CASE statements in BOL,

something like

select Field1, Field2,
case when LOSp = '.' then AdmitDt 
else dateadd(day, cast(LOSp as int), AdmitDt) END as HospDischDate

PluralSight Learning Library