SQLTeam.com | Weblogs | Forums

View definition


#1

Hi All

I need to incorporate the condition below into a view definition. Any help appreciated.
TIA
Alan
.
.
.
WHERE
If Date1 is not null then Date1 must be before Date2


#2

No exactly sure what you mean.

Try a CASE WHEN statement

CASE WHEN Date1 IS NOT NULL THEN 
    CASE WHEN Date1 < Date2 THEN Date1 ELSE Date2-1 END
END

This is of the top of my head so probable needs work.


#3

A where condition in your select statement of the create view?

WHERE
   Date1 IS NULL OR Date1 < Date2

#4

Hi djj55

The CASE solution worked with a couple of tweaks.
Thanks

Alan