Here's a simpler alternative to your query

select e.Clinic,ca.Area,
       sum(case when ca.AreaVal = 'A' then 1 else 0 end) as A,
...

It appears you have two different sets of information shoe-horned into the same table.  Maybe the information was derived from base tables which are more straightforward to query?  How is...

Hey there... so further on down the road... I was wondering how the Calendar table was defined in this answer.   Any help would be much appreciated.  This thread explains the...

In this thread:

https://www.sqlservercentral.com/forums/topic/count-number-of-days-between-two-dates-excluding-weekends-for-a-particular-month#post-3687334

The OP apparently was provided something that worked for SQL Server 2000.  It doesn't look like it was posted tho.

You're using 2008R2 and I don't think the daterange function I would use here goes back that far.  There was a similar question asked a while back and another SSC...

To split into days do you want to allocate evenly across all days or exclude weekends and holidays?

;with
unpiv_cte as (
    select
      500100 Account, 2020 [Year],
      100 Month1, 200 Month2, 300 Month3,...

C4 returns no rows

Could you please share the (appropriately quoted) insert statement from your original question?

Could you share the (appropriately quoted) insert statement from your original question?  You've asked a second question without having shared the solution to the original question.  It's frustrating because we...

I think you need a few functions for this solution.  SCDecade almost had it right, to determine the @StartDate, try:

SET @StartDate = SELECT DATEFROMPARTS(@year, ((@QuarterID -...

Ok cool

Removed

Bigint really?  It's like parking...

• This reply was modified 5 years, 9 months ago by Steve Collins. Reason: add the part with max(...)

That's nice.  I've only ever seen string aggregation (prior to Sql Server 2016) done with the the...