The procedure being called might also return data.  In this code test_proc1 calls test_proc2.  Both procedures contain a single select statement.   At...

If a stored procedure calls another stored procedure doesn't it return data to the other procedure?  The data returned would be via the input variables of the other procedure(s).

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