You're likely wasting resources by using a CROSS JOIN.  Just do a standard INNER JOIN using the LIKE comparison as the join condition.

I can't tell specifically what you want.  Here's by best guess without further details from you:

;WITH cte_state_max_sales AS (
    SELECT StateCode, MAX(Sales) AS Sales...

SQL Server does not automatically determine a row sequence, so you'll need a column in Table B that provides an order, such as an date_inserted or a $IDENTITY column.  For...

If there's still interest for this, I'd be happy to write an article about Sequences, with: set up; uses, including shared uses across many tables; possible issues; etc..

You may not be rebuilding that specific index.

The easiest way to rebuild all indexes on a table is:

ALTER INDEX ALL ON dbo.POHeader REBUILD

The linked article states that "If a date is neither a holiday, nor a weekend day, it is a workday."  But that's not true.  Businesses may be shut because of:...

It's easy and flexible to include weekends in a Calendar table, usually with two flags one that says weekends, one that says holidays.  Sometimes Christmas falls on a Saturday,...

Hmm, I don't believe I used a CROSS TAB.  Yes, I used a CASE in a SUM, but not in a CROSS TAB fashion, from my understanding of a CROSS...

Good Point Sergiy.

Public holidays are also excluded.   , but right now Id just like to solve the weekends and then see if there is a solution for hoildays...

You're welcome!  Yeah, I'm sorry too, but I couldn't figure out exactly what values to return in what columns based on your original query, so I was kinda' forced to...

Also, be aware RCSI has a 14 byte per row added overhead.  If there isn't space available in the existing data pages, you can likely expect a lot of page splits...

Do...

Thank you for your guidance and reformatting this...it is helpful.

However the main calculation that I'm looking for is to  figure out how to add the days and exclude the...

I've added some date calc ctes before the query to isolate the date calcs from the main query (also makes it much easier to test them standalone for assorted dates). ...

No problem.  I don't have a real problem with CROSS APPLY, other than the performance hit.  I personally am not a big fan of UNPIVOT, I find the syntax kludgy...