Newbie Question:If else Sql Question

• praveensc2021

  Old Hand

  Points: 333

  More actions

  May 10, 2022 at 12:58 pm

  #4030003

  In this case i am expecting the else statement to execute. please correct

  dECLARE @BusinessEntityId INT

  SET @BusinessEntityId=1003

  IF @BusinessEntityId<=(SELECT MAX(BusinessEntityId) AS BusinessEntityId FROM Person.Person)

  BEGIN

  SELECT * FROM Person.Person

  WHERE BusinessEntityID<=@BusinessEntityId

  END

  ELSE

  IF @BusinessEntityId>=1000 AND @BusinessEntityId<2000

  SELECT * FROM Person.Person

  WHERE BusinessEntityID>=@BusinessEntityId AND BusinessEntityID<=@BusinessEntityId

  • This topic was modified 2 years, 6 months ago by  praveensc2021.

• Phil Parkin

  SSC Guru

  Points: 246960

  More actions

  May 10, 2022 at 3:37 pm

  #4030132

  Your final WHERE clause makes no sense:

  WHERE BusinessEntityID >= @BusinessEntityId AND BusinessEntityID <= @BusinessEntityId;

  This is equivalent to

  WHERE BusinessEntityID = @BusinessEntityId

  Is that what you meant?

  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

• ZZartin

  SSC-Dedicated

  Points: 30920

  More actions

  May 10, 2022 at 3:41 pm

  #4030135

  Well what value does this return?

   

  (SELECT MAX(BusinessEntityId) AS BusinessEntityId FROM Person.Person)