The question now reader:

====

Assuming you have a database called playpen on SQL Server 2008 and above, what is the resul of the select statement in the following code?

use playpen

go

begin

declare

@v1 sql_variant = cast ('15.00' as float(53)),

@v2 sql_variant = cast ('15.00' as decimal(18,4)),

@v3 sql_variant = cast ('15' as tinyint),

@v4 sql_variant = cast ('00:00:15.00' as time)

select

case when @v1 > @v2

then 'v1 > v2'

when @v2 > @v1

then 'v2 > v1'

else 'v2 = v1'

end,

case when @v1 > @v3

then 'v1 > v3'

when @v3 > @v1

then 'v3 > v1'

else 'v3 = v1'

end,

case when @v2 > @v3

then 'v2 > v3'

when @v3 > @v2

then 'v3 > v2'

else 'v2 = v3'

end,

case when @v1 > @v4

then 'v1 > v4'

when @v4 > @v1

then 'v4 > v1'

else 'v4 = v1'

end

end

====

And the answers corrected to:

A: v2 = v1, v3 = v1, v2 = v3, v4 = v1

B: error indicating float and time are incompatible

C: v1 > v2, v1 > v3, v3 > v2, v4 > v1

D: v1 > v2, v1 > v3, v2 = v3, v4 > v1

E: v2 = v1, v1 > v3, v2 > v3, v1 > v4

F: none of the above

====

v2=v3 matches in answers A and D

Points have been awarded back to everyone to this point.