I can't test it (don't have the table) and all of your column names are reserved words so here's a swag at it:

with range_cte(ID) as (
select
 ...

Why not just create a primary key in table A?

If 'jsonpayload' is valid JSON it could be updated in place.  Using Sql 2016+ something like this (copy, paste, run) could work:

/* create a test table with...

• This reply was modified 6 years, 1 months ago by Steve Collins.

Is there a business definition that defines an "error" or is the error table only supposed to contain errors generated by sql?  Please post the definition of the student table...

I wasn't taking into consideration the Convert.To/FromBase64 calls that are used with the decryption method, so I wasnt converting to or from Base64 when i was performing the substring,...

The MySQL is...

Could you provide the definitions for the tables that you reference?  Is there an integer identity primary key on id in the student table?

Here's a tvf named 'left_chars' that attempts to generalize all of the requirements.  Sorry I'm learning about APPLY (new hammer) so everything looks like a nail.  The function should work...

If the dollar values are randomly distributed across rows then any sample (of sufficient size, about 35 for reasonable precision and confidence) should have an average $/cust that's close to...

It would be similar to what was posted except using your calendar table instead of the daterange function.  Eomonth can't be used either because it's Sql 2016+.

Something like this:

            
October 8, 2019 at 2:28 pm
            
#3687010

            
            
                                                
        

Yea yea, I know or I noticed after I posted that.  Instead of eomonth() you could use:

dateadd(day,-1,dateadd(month,1,@test_month))

Then you could use a tally table and dateadd function.  Or...

This is an application for Jonathan's daterange function.  Here is his article:

https://www.sqlservercentral.com/scripts/a-daterange-table-valued-function

Something like this:

declare
   @input_yearint=2019,
   @input_monthint=9;
declare
  @test_monthdate=datefromparts(@input_year,@input_month,1);

 select
   count(*) days_in_month_excluding_wkends
...

I'm thinking of check where the status is that of 12 as in the example for a month period, this is done via a mechanism of a table that...

The top(1) protects from row expansion due to the inequality on date.  That was the part I wasn't getting.

 

If I'm understanding correctly there's a table with many status columns per userid.  When any of the statuses change a new record is inserted which duplicates the unchanged statuses.  Fyi,...