What specifies what days show column B. Is it purely that it has a value of your parameter @p_date? If so, what you're looking for is a CASE...

Duplicate of https://www.sqlservercentral.com/Forums/1903690/Set-up-job-to-convert-word-document-to-pdf, where discussion already taken place.

You should know better than to post a question without DDL and DLM. 🙂

Without that, I'd suggest using CTEs to get your initial dataset, then resolve your results...

The other thing to note is John used GROUP BY in his query, to cater for partitions. You've used a DISTINCT and dropped the GROUP BY. If you have partitions,...

Instead of using a JOIN, try using a LEFT JOIN to your tblproductAttributes.

If you want a more in depth answer (with an example), have a look at the...

You say you've tried in your latest post (in your duplicate topic). Moving the topic back to your original thread, what is it you've tried since further input...

Depends...

Correct Andreas. As of SQL Server 2016, only 64bit is available.

Assuming that 01-02-2017 is 2nd January 2017, then full script with correct data types and date values:
USE Sandbox;
GO

CREATE TABLE Discounts (
  ProductCode VARCHAR...