Perhaps something like this?

SELECT
    RefDocNum,
    MAX(AcctDocNum1) AS AcctDocNum1,
    DocType1,
    LocCrdtAmt,
    LocDbtAmt
FROM 
...

Huh? I don't understand what you're saying. It doesn't...

• This reply was modified 3 years, 4 months ago by kaj. Reason: Typo

In a set-oriented language you return the whole set of values that are temporally equal toMight wan the min(date diff) over(patition by account) .

Look up Dr. Codd's T-Join for...

• This reply was modified 3 years, 4 months ago by kaj.

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, 5 months 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...