Hi Gurus,

I am not able to make much progress.If I have the below

if (select count(*) from FROM [ReorderS] where Item is not null) > 0

I get error incorrect systax near > and also what will be in the ELSE part?