Is it possible to print a variable in stored procedure

[Deepthi 21456]

I am adding my code below

create procedure dist_profit_pairs1(IN user_id
varchar(20),IN plan varchar(20))
begin
DECLARE left_bvs,right_bvs Float DEFAULT 0;
SELECT sum(businessvalues)as left_bvs from bv_history where userid=user_id and type='Distribution Profit' and position='Left';
SELECT sum(businessvalues)as right_bvs from bv_history where userid=user_id and type='Distribution Profit' and position='Right';

IF left_bvs < right_bvs THEN
SELECT left_bvs;
ELSE
SELECT right_bvs;

[nainakarri]

Hi I assume you want to print the variable value when executing in sqlserver studio management. If so, you can print the variable value by

print variablename

regards Naina

Naina

[vanikanc]

The printed value has to be a varchar or char. So, please cast the value to a varchar before printing.