case statement

• jagjitsingh

  Ten Centuries

  Points: 1059

  More actions

  December 15, 2021 at 11:00 am

  Go to Answer

  #3963838

  Hi

  In below line i want if when > 0 instead of 0 then what should i change

  (Select Case (select count(*) from tbl1 T where T.num = T0.num ) when 0 then

  Thanks

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  December 15, 2021 at 11:13 am

  Answer

  #3963843

  DECLARE @x INT = 5;
  
  SELECT Result = CASE
                      WHEN @x > 0 THEN
                          'GT0'
                      ELSE
                          'NOT GT0'
                  END;

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel