0

i have a very simple S/P called ClaimTotal

CREATE PROCEDURE ClaimTotal
@Result varchar(50) OUTPUT 
as
select sum(total) as Ctotal
from claim

i am struggling to get the Ctotal saved into the @result so that i can
then pull this into my .net program.

if anyone could help that would be very helpfull

thanks in advanced.

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by Mike Bishop
0
CREATE PROCEDURE ClaimTotal
@Result varchar(50) OUTPUT 
as
select sum(total) into Result 
from claim

Edited by smantscheff: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.