Okay, I'll give it a shot...

DECLARE
    @tableA TABLE (
        Id       ...

Just to play the devil's advocate here and make you think: 🙂

How do you want to handle if the date in Table A is right in the middle between two...

even on the same version but with different server specs it can return different results - I would not consider it a bug but rather a consequence of using...

Is this a question or just a comment? What do you need?

Okay, but do you...

• This reply was modified 3 years ago by kaj. Reason: Rephrasing

This is a personal preference, but I find your case structure difficult to parse and comprehend.

Instead of your

where finvdate < Case when Month(current_timestamp) = 1 then
Dateadd(year, DateDiff(year,'19060101',...

How about something like this?

WITH ssn_empID AS (
        SELECT DISTINCT 
         ...

The default precision and scale of the numeric type is 18,0 and my guess is that one or more rows have a value that exceed the default precision of 18.

As...

Your could try to use Azure Data Studio as an alternative tool for your documentation.

Generally speaking the easiest way to achieve your "roll up" is to use a GROUP BY on StudentID and then for each of your names do a MAX or MIN,...

If I have interpreted your question correctly, you could try something like this:

DECLARE @SQL NVARCHAR(MAX) = N'
WITH util AS (
    SELECT 
  ...

What is the relationship between the first part about putting a query into a declared variable and the published formatted query? I'm confused.

The only part of the update query that...

Hmmm... maybe like this?

SELECT
    CONCAT(SCHEMA_NAME(t.schema_id), '.', t.name) AS TableName
    , t.create_date AS CreatedDate
    , t.modify_date AS LastModifiedDate
 ...

It doesn't work in the supplied query? I mean, I already added the...

Hmmm... I'm pretty sure that IP address is one...