I've decided to start a list of questions for canidates (or so I can remeber when I gotta go)...ones that I've run across and was confused by (yeah, yeah, there's not enough drive space available...so I'll keep it breif)
Q:What do you do with an index intersection?
A: Look both ways, before you cross join.
1. Why do the 2 statements below return different results?
declare @l decimal(38,2)
select @l = 24.35
if @l - convert(int,@l) = 0
select floor (@l)
select case when @l - convert(int, @l) = 0 then floor (@l)