OK, but I still can not figure this out. OR does not work. What I need to find out is to gather data for customers who had invoices before...

I wouldn't write dates as '09/01/2022'

What does it mean? Is it 1st September or 9th January?

Better to write dates in ISO format so for 9th January 2022 write it as...

Wouldn't you add the absolute values?

5% + abs(-5%)  + abs(-3%)

Do you think it's not a good thing? and how do you think like it's a HW work(it's not a HW but I would say type of that).  anyhow...

Now has got the answer he wanted he's deleted the evidence. 🤣

Here you go, this is an answer for your homework lol:

select t1.station_name, count(distinct t2.station_name) reachable_stations
  from train_st t1
  left join train_st t2
   ...

You could add a constraint to the table to ensure that one of the values is null and one is not null:

ALTER TABLE DieselTransaction
  ADD CONSTRAINT...

You can do it in a more straight forward way using OFFSET:

DECLARE @PAGE INT = 1;

WHILE (@PAGE <= 5)
    BEGIN
    ...

I would find having "-- (Values)" between the insert and select statements very annoying.

For me having more new lines and some decent indentation would make it a lot more maintainable.

Why don't you want to make supplier and machine column accept null?

Why can't you use CTEs?[/quote]

I want to compile a view into a third party system that does not support CTEs. If it's not possible to accomplish without CTEs I...

I...

Drew showed me his wonderful code to do this same thing on another thread.  I did a deep dive on it and the concept is wonderfully simple and it...

Here is a comparison of the two methods:

/* Windowed Aggregate (MAX)  */Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead...

Here is a comparison of the two methods:

/* Windowed Aggregate (MAX)  */Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0,...

• This reply was modified 4 years, 1 months ago by Jonathan AC Roberts. Reason: added execution plan