Thanks for everyone's generous responses - the extra parenthesis was definitely the issue!

Thanks everyone for your generous contributions. Ultimately I found three single talking marks to be most effective, '''!

...

WHERE T1.DocDate >=''' + @fromDate + ''' AND T1.DocDate <=''' + @toDate +...

Hi MickyT,

After reading through the links that you kindly provided, and investigating the query which you generously shared I came to realize that my specific challenge is that I do...

Hi MickyT,

Thanks for your response, and advice. I will read the tutorials that you indicated and then study the sample query that you supplied.

Kind Regards,

Davo

Hi ChrisM@Work,

I am trying to better understand your solution, towards this end I have started with the inner most brackets -

SELECT DATEDIFF(MONTH, 0, GETDATE())

Upon first inspection I expected this part...

Thank you, using IN did the trick!

Hi Indu,

This works great for static data held in variables, however I want to achieve the same outcome using actual data contained in tables. Can you please explain how to...

Hi Indu,

Thank you for your response. Initially when I tried to specify the decimal values parameters, e.g.: DECLARE @dividend decimal(10,3), I was met with 'red underlines' in SSMS. However something...

Thanks Chris, your explanation is very helpful. I now have a much better understanding of NULLIF and ISNULL.

Hi ChrisM@Work,

Thank you for your suggestions. I have now managed to find the line in my query which is returning NULL values.

(T0.TotalSales - T0.StockValue) / NULLIF(T0.StockValue, 0) AS 'Gross Profit...

Hi All,

It is possible to download the Microsoft SQL Server Management Studio by itself.

Microsoft SQL Server Management Studio (various versions)

Using one of the installation packages from above it is not...

Thanks again, I am using the top code excerpt that you kindly shared, and everything is working great! 🙂

Thanks so much for your advice. I will give this a crack tomorrow after a good nights sleep!

Hi Koen,

I am not really following - can you please edit the code block below?

, CASE WHEN

CAST(CAST(ROUND(((T0.LineTotal - T0.StockValue) / NULLIF(T0.StockValue, 0)) * 100, 2) AS decimal(10,2)) AS...

Hi Everyone,

A colleague has kindly just shared with me that Collation on specific columns is required in this instance, rather than on the join itself. Please see below...

Kind Regards,

David