i am trying to write a SP that will return a value in vb.net
here is my SP
CREATE PROCEDURE ClaimTotal @Ctotal BIGINT output
select SUM(total) from claim
where @ctotal = total
I want to SUM my total coloum from my table claim, and store this in a
varible called @ctotal so then i can pull this into vb.net
this is all new to me, as i do normal select queries but i have read that stored procedures are the way to go.
please please help a newbie
also how would i then pull the @ctotal into vb.net?