sql - Can some please help me and show me what I'm doing wrong -

sql - Can some please help me and show me what I'm doing wrong -

create table daterange ([date] datetime, isfutureorpast bit) declare @date datetime set @date ='2014-01-01 00:00:00.000' while @date <='2014-12-31 00:00:00.000' begin insert daterange ([date]) values (@date) set @date = @date + 1 end --case statement check values , come in flag declare @currentdate datetime = getdate() update daterange set [date] = case when @currentdate <= [date] 0 else 1 end ispastorfuture daterange [date] in ( 0, 1)

try this:

declare @daterange table ([date] datetime, isfutureorpast bit) declare @date datetime set @date ='2014-01-01 00:00:00.000' while @date <='2014-12-31 00:00:00.000' begin insert @daterange ([date]) values (@date) set @date = @date + 1 end --case statement check values , come in flag declare @currentdate datetime = getdate() update @daterange set isfutureorpast = case when @currentdate <= [date] 0 else 1 end @daterange select * @daterange

sql sql-server