how to use count in a storedporcedure

See more:

SQL-Server

Hi friends,

The following is my table value for customerdetails

CustId	CustName	BookingDate	         Noofseats   	RowName
111	Rajkumar	2013-05-08 00:00:00.000 	5	   A         
112	palani	        2013-05-08 00:00:00.000         8	   A   

and my query is

alter procedure sp_insertticketsforcustomer(@custid int,@custname varchar(50),@date datetime,@noofseats int,@rowname char(10))
as
begin
declare @noofcounts int
select @noofcounts= COUNT(Noofseats) from CustomerDetails where RowName=@rowname
select @noofcounts
end

here i just want to select how many seats already allocated for a particular rowname and when i given seats more than availablity it shoud return how many seats available in the row.here i just select how seats allocated for particular row.

exec sp_insertticketsforcustomer 113,'palani','2013-05-08 00:00:000',30,'A'	

this is my next input so when this execute it return available seats no not enough for registration.when i execute this query it return 2 for noofseats rather than 13.how can i change this one. available seats is 40 that is set in another table.

Thank you