I don't mean to high-jack the post or anything, but how come when converting a DATETIME variable to a FLOAT there is no error thrown? There are '-' characters in...

Yeah, that seems to have solved it. I uninstalled SQL Server 2005 and then installed SQL Server 2000 and 2005 respectively, and its all working now.

Thanks

Tryst

OK, thanks for the reply.

I will uninstall SQL Server 2005, and then install SQL Server 2000 and 2005 respectively.

Tryst

Could the order of your DateTime value be correct (or differently is the correct word). USA Datatime is mm/dd/yy, whilst UK is dd/mm/yy. Maybe you need to use the CONVERT...

Hi rsharma, thanks for the reply.

I actually got to another solution with the help from someone on another forum.

This is the solution...

select t911.id

, t912.value -...

Hi all,

I am new to this forum, and noticed this thread and thought this is more or less the same issue we have at the moment in work.

We have a...