Combining to criterias into one Case Statement

[luvmy2kids]

I have the below statements:

SET @QtrClose = getdate()

SELECT @QtrClose = CloseDT from prtaxperiodclose where TaxPeriodID = @Qtr and TaxPeriodYear = @Year

What I need to accomplish by combining the 2 is:

When CloseDT is null set it = getdate(), otherwise -
SELECT @QtrClose = CloseDT from prtaxperiodclose where TaxPeriodID = @Qtr and TaxPeriodYear = @Year

How can I combine the 2 to make it work. The issue I am having is when the closedt hasn't been entered it is not pulling back any data.

 

[bborissov]

SELECT @QtrClose = CASE WHEN CloseDT IS NULL
                             THEN GETDATE()
                        ELSE CloseDT END
       FROM prtaxperiodclose
WHERE TaxPeriodID   = @Qtr AND
      TaxPeriodYear = @Year

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[luvmy2kids]

Thanks!

 

[markros]

Or

SELECT @QtrClose = COALESCE(CloseDT,GETDATE())
       FROM prtaxperiodclose
WHERE TaxPeriodID   = @Qtr AND
      TaxPeriodYear = @Year