Click here to Skip to main content
11,644,731 members (66,691 online)
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
0 OriginalGriff 680
1 jyo.net 494
2 Sergey Alexandrovich Kryukov 464
3 Afzaal Ahmad Zeeshan 424
4 CPallini 386
0 OriginalGriff 1,020
1 Sergey Alexandrovich Kryukov 673
2 DamithSL 656
3 Afzaal Ahmad Zeeshan 652
4 CPallini 555


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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100