sql - I want to do and update with a case statement and End AS but getting error incorrect syntax near 'AS' -

sql - I want to do and update with a case statement and End AS but getting error incorrect syntax near 'AS' -

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)

the as ispastorfuture has no meaning query. remove it.

however, @ point you're trying assign 1 or 0 column named [date], doesn't create much sense. trying add together new column table? if so, need first run alter statement on table add together column.

sql sql-server