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: 246960

  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
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin