thank you everyone for your feedback.  i will implement as noted.

deleted post

• This reply was modified 1 month, 1 week ago by  water490.

deleted post

• This reply was modified 1 month, 1 week ago by  water490.

Yes - you definitely need to be using precedence constraints between tasks.

1. Reads (select) don't block other reads - locks on a select could prevent inserts/updates/deletes on the table(s)...

deleted post

• This reply was modified 1 month, 1 week ago by  water490.

First of all, the warning was telling you that you have columns that you're doing aggregates like SUM() and COUNT() on contain some NULL values.  Are you...

deleted post

• This reply was modified 1 month, 1 week ago by  water490.

google is your friend - you should have done it first.

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-ansi-warnings-transact-sql?view=sql-server-ver16

regarding the code and because you got a timeout  I would add a command timeout before the...

• This reply was modified 1 month, 1 week ago by  water490.

Thank you so much!

Not sure if this will be any faster, you might have to look at putting indexes on the table if it is not:

;with cte as
(
 ...

I think I fixed the issue.  I added t_date to the partition part and now I am getting the correct number of records.  The query is super slow...

I think I fixed the issue.  I added t_date to the partition part and now I am getting the correct number of records.  The query is super slow though.  It...

Seems like you could achieve this with a couple of CTEs. I assume that the value of T_date could differ, hence why I use window aggregation functions rather than...

the queries are giving the correct output now.

thank you both so much!

Thank you both!!  I appreciate your help so much!

I tested another scenario.  I added a different company in the list so there are now two not one company.

Drew, your solution...

• This reply was modified 7 months, 3 weeks ago by  water490.