Viewing 2 posts - 1 through 2 (of 2 total)
Agreed on #1
On #2: In the explanation they say that the problem is basically that NULL is not the same datatype as 'Idle', when I used ISNULL() and replaced NULL...
March 1, 2012 at 6:59 am
#1453592
Very easy remedy to this problem: ISNULL() function
select * from Statuses s
Where ISNULL(s.Stat,'NULL') not in ('NULL', 'Idle')
March 1, 2012 at 6:22 am
#1453575