The Weird and The Wonderful

d@nish wrote:

What is wrong with problem elimination?

select *
from dbo.Departments
where (accountnumber = @accountnumber and LEN(@accountnumber) >= 4)
   or catid = @catid
order by deptname

public class SanderRossel : Lazy<Person>
{
   public void DoWork()
   {
      throw new NotSupportedException();
   }
}

Sander Rossel wrote:

I'm wondering what the problem is exactly...

manchanx wrote:

Hopefully not your new client/employer?

if (select COUNT(*) from tblSettings where 'test' = 'true') = 0
begin
  if LEN(@accountnumber) >= 4
  begin
    select * from dbo.Departments where accountnumber = @accountnumber order by deptname;
  end
  else
  begin			
    select * from dbo.departments where catid = @catid order by deptname;
  end
end
else
begin
select *
  from dbo.Departments
  where (accountnumber = @accountnumber and LEN(@accountnumber) >= 4)
     or catid = @catid
  order by deptname
end;

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

EXEC GetClientDepartments @accountNumber = 'xxxxxxxx';
-- or...
EXEC GetClientDepartments @catId = 'xxxx';