I am trying to make one select from these two senarios but it is not working:
Select Sum(CASE When H_HA_ID = 6 Then 1 Else 0 End) As CallsMade,
Sum(CASE When H_HA_ID = 3 Then 1 Else 0 End) As Emails,
Sum(CASE When H_HA_ID = 10 Then 1 Else 0 End) As SMS
From History Where H_IDX = 192652 And H_DateTime > DATEADD(DAY, -30, GETDATE())
Select Sum(CASE When H_HA_ID = 6 Then 1 Else 0 End) As CallsMade,
Sum(CASE When H_HA_ID = 3 Then 1 Else 0 End) As Emails,
Sum(CASE When H_HA_ID = 10 Then 1 Else 0 End) As SMS
From History Where H_IDX = 192652 And H_DateTime >= DATEFROMPARTS(YEAR(GETDATE()),MONTH(GETDATE()),'01')
This is my attempt:
Declare @DateChoice VarChar (25)
Set @DateChoice = '30 Days'
Select Sum(CASE When H_HA_ID = 6 Then 1 Else 0 End) As CallsMade,
Sum(CASE When H_HA_ID = 3 Then 1 Else 0 End) As Emails,
Sum(CASE When H_HA_ID = 10 Then 1 Else 0 End) As SMS
From History Where
Case @DateChoice
When '30 Days' Then H_IDX = 192652 And H_DateTime > DATEADD(DAY, -30, GETDATE())
Else
H_IDX = 192652 And H_DateTime >= DATEFROMPARTS(YEAR(GETDATE()),MONTH(GETDATE()),'01')
End
Please help with my coding issue.