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.

Recommended Answers

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

All 2 Replies

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.