Passing sum to stored procedure

• ssandu

  SSC Enthusiast

  Points: 143

  More actions

  September 21, 2015 at 3:42 am

  #321378

  Hi

  Is it possible to pass a sum of vars to a SP ?

  I've tried this but it gives me an error

  exec mysp

  @param = (@var1 + @var2)

  Thank you !

• Kristen-173977

  SSCrazy Eights

  Points: 8687

  More actions

  September 21, 2015 at 3:45 am

  #1828024

  The only operation permitted in the EXEC command is to concatenate strings.

  So you would have to add your two variables first, and then use THAT parameter in the EXEC command