Styjun

How can AnyDVD destroy a DVD drive?

Novel set in the future, children cannot change the class they are born into, one class is made uneducated by associating books with pain

How can a company compel a W2 employee to sign a non-compete agreement?

Shortest way to get an EOF Error

How should I tell a professor the answer to something he doesn't know?

How can I find out a substance name based on its structural formula?

Knights and knaves puzzler

How to respond when insulted by a grad student in a different department?

What is the German word for: "It only works when I try to show you how it does not work"?

How to protect my Wi-Fi password from being displayed by Android phones when sharing it with QR code?

Closed unit ball of an infinite-dimensional Banach space is not compact

How to handle shared mortgage payment if one person can't pay their share?

Why is it popular to teach modulus via the example of mod 12 and analogue clocks?

Planet that goes through its entire history in a matter of Earth days

Tikz arrows not showing correctly

I didn't do any exit passport control when leaving Japan. What should I do?

Hieroglyphs numerals

'The Kukhtarev's model' or 'Kukhtarev's model' ('John's car' or 'The John's car')?

SSD or HDD for server

Would a physician with migraine better treat their patients?

Why is `decltype(static_cast<T>(...))` not always `T`?

Is it true that if we start a sentence with 'the', this 'the' can be omitted?

Which collation should I use for biblical Hebrew?

How can a "proper" function have a vertical slope?

Can't find the total in and out of business hours with COUTN CASE

tsql : is it possible to do nested case statements in a select?coldfusion count case error depending on datasourceSAS Enterprise Guide Count IFHow do I count distinct and total users and logins by date range across two tables?How to use case statement with select and group bySQL calculating percentage over COUNTtwo counts in the same rowRPAD and CASE statment - Oracle SQL - Missing Right Parenthesis ErrorSQL query syntax in CASE WHEN ELSE END to countDistinct Count when using Case When Statement in SQL Server

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

0

I am trying to make working the COUNT CASE WHEN statement.

I want to calculate the total between 8-17h and another total outside these hours. My query below always return the grand total.

SELECT DISTINCT tSource,
 COUNT(case when (tTime between '08:00:00' and '17:00:00') then 1 else 0 end) as tIN,
 COUNT(case when (tTime not between '08:00:00' and '17:00:00') then 1 else 0 end) as tOUT

FROM @tTable 

tTotal tIN tOUT
28 13 15
4167 1167 3000

count case case-when

share|improve this question

edited Mar 29 at 1:14

halfelf

7,1001111 gold badges3636 silver badges5050 bronze badges

asked Mar 28 at 21:23

Eric LiEric Li

111 bronze badge

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Try SUM instead of COUNT. Also, it's helpful to tag your post with the specific database you're using; you'll get more useful answers that way.
  
  – A. S. K.
  Mar 28 at 21:56
  

  
  
  
  

add a comment
 | 

0

I am trying to make working the COUNT CASE WHEN statement.

I want to calculate the total between 8-17h and another total outside these hours. My query below always return the grand total.

SELECT DISTINCT tSource,
 COUNT(case when (tTime between '08:00:00' and '17:00:00') then 1 else 0 end) as tIN,
 COUNT(case when (tTime not between '08:00:00' and '17:00:00') then 1 else 0 end) as tOUT

FROM @tTable 

tTotal tIN tOUT
28 13 15
4167 1167 3000

count case case-when

share|improve this question

edited Mar 29 at 1:14

halfelf

7,1001111 gold badges3636 silver badges5050 bronze badges

asked Mar 28 at 21:23

Eric LiEric Li

111 bronze badge

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Try SUM instead of COUNT. Also, it's helpful to tag your post with the specific database you're using; you'll get more useful answers that way.
  
  – A. S. K.
  Mar 28 at 21:56
  

  
  
  
  

add a comment
 | 

I am trying to make working the COUNT CASE WHEN statement.

I want to calculate the total between 8-17h and another total outside these hours. My query below always return the grand total.

SELECT DISTINCT tSource,
 COUNT(case when (tTime between '08:00:00' and '17:00:00') then 1 else 0 end) as tIN,
 COUNT(case when (tTime not between '08:00:00' and '17:00:00') then 1 else 0 end) as tOUT

FROM @tTable 

tTotal tIN tOUT
28 13 15
4167 1167 3000

count case case-when

share|improve this question

edited Mar 29 at 1:14

halfelf

7,1001111 gold badges3636 silver badges5050 bronze badges

asked Mar 28 at 21:23

Eric LiEric Li

111 bronze badge

SELECT DISTINCT tSource,
 COUNT(case when (tTime between '08:00:00' and '17:00:00') then 1 else 0 end) as tIN,
 COUNT(case when (tTime not between '08:00:00' and '17:00:00') then 1 else 0 end) as tOUT

FROM @tTable 

tTotal tIN tOUT
28 13 15
4167 1167 3000

share|improve this question

edited Mar 29 at 1:14

halfelf

7,1001111 gold badges3636 silver badges5050 bronze badges

asked Mar 28 at 21:23

Eric LiEric Li

111 bronze badge

share|improve this question

edited Mar 29 at 1:14

halfelf

7,1001111 gold badges3636 silver badges5050 bronze badges

asked Mar 28 at 21:23

Eric LiEric Li

111 bronze badge

edited Mar 29 at 1:14

halfelf

7,1001111 gold badges3636 silver badges5050 bronze badges

edited Mar 29 at 1:14

halfelf

7,1001111 gold badges3636 silver badges5050 bronze badges

asked Mar 28 at 21:23

Eric LiEric Li

111 bronze badge

asked Mar 28 at 21:23

Eric LiEric Li

111 bronze badge