Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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
Posted 7-May-13 22:27pm
Comments
gvprabu at 8-May-13 5:35am
   
hi... Ready Aggregated Functions... :-)

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Use SUM Not Count
alter procedure sp_insertticketsforcustomer(@custid int,@custname varchar(50),@date datetime,@noofseats int,@rowname char(10))
as
begin
declare @noofcounts int
select @noofcounts= SUM(Noofseats) from CustomerDetails where RowName=@rowname
select @noofcounts
end
Happy Coding!
Smile | :)
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 710
1 OriginalGriff 543
2 Abhinav S 318
3 thatraja 245
4 Tadit Dash 140
0 Sergey Alexandrovich Kryukov 8,322
1 OriginalGriff 4,790
2 Peter Leow 3,784
3 Maciej Los 3,515
4 Er. Puneet Goel 3,107


Advertise | Privacy | Mobile
Web03 | 2.8.140415.2 | Last Updated 8 May 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid