Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Help with count

Author  Topic 

Diablos
Starting Member

10 Posts

Posted - 2015-10-29 : 12:57:23
Hi
I'm having problems with the following count:
Here is my data
Bus Starting Date End Date
4561 2015-10-26 00:00:00.000 2015-10-26 00:00:00.000
4614 2015-10-28 00:00:00.000 2015-10-28 00:00:00.000
4443 2015-10-26 00:00:00.000 2015-10-28 00:00:00.000
4521 2015-10-27 00:00:00.000 2015-10-27 00:00:00.000
4615 2015-10-28 00:00:00.000 2015-10-28 00:00:00.000

I want to know the total number of bus active based on the start and end by day,the result should be
- day 26 i have 2 bus active (4561 and 4443)
- day 27,the result is 2 (4521 and 4443)
- day 28 the result is 3 (4614,4443,4615).
i've tried with between but to no result.
Thanks for your help!!


vedjha
Posting Yak Master

228 Posts

Posted - 2016-06-18 : 12:12:05

select count (bus), bus from table_name where EndDate between 'mm/DD/yy' and 'mm/DD/yy' group by bus having count (bus)>0

http://kiransoftech.com
Go to Top of Page

vedjha
Posting Yak Master

228 Posts

Posted - 2016-06-18 : 12:12:06

select count (bus), bus from table_name where EndDate between 'mm/DD/yy' and 'mm/DD/yy' group by bus having count (bus)>0

http://kiransoftech.com
Go to Top of Page
   

- Advertisement -