Member Avatar for Mike Bishop

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
  • 110 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Mike Bishop
Member Avatar for smantscheff 
CREATE PROCEDURE ClaimTotal
@Result varchar(50) OUTPUT 
as
select sum(total) into Result 
from claim
Edited by smantscheff because: n/a
Member Avatar for Mike Bishop

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.