Show result values based on paramter value

• komal145

  SSCrazy Eights

  Points: 9915

  More actions

  June 15, 2017 at 12:25 pm

  #337667

  I have a Stored Procedure with paramter @percentage
  I need to show the result ( records) based on two columns

  Example: Result set has columns
  Percentage , weekpercentage
  10                11
  26                12
  12                34

  If i choose @percentage =12

  I should check the above three records and choos the result.

  Example : result will be
  Percentage , weekpercentage
  26                12
  12                34

  How do i check this in query

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  June 15, 2017 at 12:56 pm

  #1947014

  WHERE Percentage=@percentage or WeekPercentage=@percnetage