Home Forums SQL Server 2008 SQL Server 2008 - General sql query implementaion RE: sql query implementaion

  • December 3, 2012 at 12:33 am

    #1564748

    just we add else statement here

    case when MaxSalary is not null then 'Yes' else 'no' end MaxSalary,

    case when MinSalary is not null then 'Yes' else 'no' end MinSalary