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.

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

thanks nowworking fine,

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.