There are actually two things wrong, the one the correct answer refers to and the additional problem that on an insert, no records will be inserted due to the inner...

Select @var1=col1, @var2=col2 from table where....

HTH

The integer portion of a datetime is the date and the fractional is the time. I don't know the details of how it's stored though.

What are you trying to do...

For some reason I couldn't reply to your other post...

I've found that inserting a date into SQL in the format yyyy/mm/dd is often best. It's unambiguous.

Maybe you can switch the...

By default, a primary key is supported by a unique clustered index, so by dropping the key and creating the index you won't be gaining anything.

You will gain if...

Alternatively if you want to avoid the conversion to char

select count(*) from WHERE

cast(floor(cast([datetime] as float)) as datetime) = cast(floor(cast(getdate() as float)) as datetime)

The above is faster than a...