Thank you all for your input - really appreciated!

Drew / Chris

Thank you both. I see now the solution was more than obvious. Massive thanks!

I can also add a line to it, but then it will always return the first, empty record as from the example below, no?

IF OBJECT_ID('tempdb..##invoice') IS NOT NULL

The result set will be per invoice, but not all Direct payments will have TRUE in their Add VAT to CC column. Some may have FALSE ,e.g. product's insurance.

Yes, thank you.
But is it OK, from performance point of view, to call the same table twice, please? The actual table has 16M records.

ThomasRushton (12/30/2016)

---

y'know, that was my first answer... but I censored...

Chris Harshman (12/30/2016)

---

BOR15K (12/30/2016)

---

...I am aware of the dirty data and in this case there will be no update of the data within the selected range, hence I want to...

Jeff Moden (12/30/2016)

---

BOR15K (12/30/2016)

---

Jeff Moden (12/30/2016)

---

BOR15K (12/30/2016)

---

With regards to the TOP 1 I appreciate it might sound weird, but this what the customer require - to fetch the first value,...

Jeff Moden (12/30/2016)

---

BOR15K (12/30/2016)

---

With regards to the TOP 1 I appreciate it might sound weird, but this what the customer require - to fetch the first value, disregarding the order,...

Thank you for the answers.

I am aware of the dirty data and in this case there will be no update of the data within the selected range, hence I want...

Thank you, Ed. Can you...

DesNorton (12/7/2016)

---

If you use invoice_lines_I03 to...

Currently none. The table has lots of records periodically loaded at once (every other hour or so).

Thank you. Yet I will need to seek a permission from DBA's to add a new column across all the environments.