Newbie Question Regarding Conditional Statement

[caper11752]

Hi all,

I need to create a VIEW in SQL 2005 and need some assistance. I'm sure this is possible but it has me stumped. We have a table with several fields, such as Name, StartDate and EndDate. I need the VIEW to return Name, and another field with either True or False in it. So if the difference between StartDate and EndDate is less than 365 days then TRUE, else FALSE.

Thanks if advance

 

[gmmastros]

[tt][blue]
Create View YourViewName
As
Select Name,
Case When DateDiff(day, StartDate, EndDate) > 365
Then Convert(Bit, 0)
Else Convert(Bit, 1)
End As AliasName
From YourTable
[/blue][/tt]

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Look at DATEDIFF function Help in BOL.

Select Name, cast(case when datediff(day, EndDate, StartDate) <365 then 1 else 0 end) as bit) as IsLessThanYear from myTable

 

[markros]

Every time I click on reply and submit on a new post I see 2 replies and it has to be either George or Boris.

 

[markros]

BTW, I forgot to put Name in [], e.g.

select [Name], ...