procedure

[Guest_imported]

hi friends

when i try to send parameter with arthematics expressions its give error like this

execute myprocedure @name,@parameter1 * @parameter2
when i send any arthematics expression it give

thanks

 

[tlbroadbent]

A stored procedure cannot accept expressions as parameters. Declare another parameter to hold the result of the arithmetic expression and send that parameter to the stored procedure.

-- define data type needed
Declare @parameter3 Decimal(18,4)

-- evaluate the expression and assign to @parameter3
Set @parameter3 = @parameter1 * @parameter2

-- call SP using @parameter3
execute myprocedure @name, @parameter3 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.