if you need the actual count, instead of just checking for orders, try this way:
declare @TheCount int
select @TheCount = count(*) FROM [ReorderS] where Item is not null
if @TheCount> 0
BEGIN
--do stuff
END
ELSE
BEGIN
--do other stuff
END
alternatively, you can use EXISTS:
if EXISTS(SELECT * FROM [ReorderS] where Item is not null)
BEGIN
--do stuff
END
ELSE
BEGIN
--do other stuff
END
Lowell