Duplicate of https://www.sqlservercentral.com/forums/topic/is-it-possible-to-add-a-scripts-folder-to-a-reporting-services-project-2

• Many users are wary of opening Excel or Word documents, as they can contain malicious macros/scripts. Can you generate DDL (Create table script) for the table (including indexes), &...

You just want to concatenate all the IssueName values? If you don't care about order, you can use STRING_AGG function:

SELECT STRING_AGG(IssueName,',') AS IssueNames FROM dbo.tempIssueRange;

Given that you know the from and to time zone (i.e., you know the offset difference), but your values are not datetimeoffset, why don't you just use dateadd()?

AT TIME...

Maybe something like Monarch? I used a product called Monarch decades ago that sounds like this tool.

There are some industries/groups of customers with more discipline than others, and some...

<reference_number> is an element, not an attribute.

That error seems to indicate you're not using SQL Server 2022. (Which is probably why DesNorton wrote " (NOTE the extra parameter in STRING_SPLIT)"

Are you on SQL Server 2022? You...

You probably have one or more calculations w/ a result > 100

Contrived example...  This succeeds:

This succeeds:
SELECT 'Symbol',
'2023-05-02',
CAST(IIF(0 = -1, 0, 1.0 * 1.234567 / .01234567) AS NUMERIC(7,4))...

Post duplicated

What are the data types (w/ precision & scale) of T3.P_V, T4.C_V, T3.P_O, T4.C_O, T3.P_D, & T4.C_D?

Can you provide a sample script of failing data?

Your example using

WHERE PRM_StartDate = (SELECT MAX(PRM_StartDate) FROM PriceMatrix)

would , fixing the double WHERE, only return rows where PRM_StartDate is the maximum where  IMA_ItemStatusCode = 'Active'.

So...

Based on some other links, try replacing & with %26

https://www.sqlservercentral.com/forums/topic/reportviewer-doesnt-work-if-a-parameter-contains-an-ampersand

&amp;

PLAN & COUNT are reserved keywords. If you're going to use them as an object (e.g., column) name or alias, you need to wrap them in double quotes or...

Posting DDL & insert scripts rather than links to download is more likely to get you help.

How to post code problems

Not getting snippy with a generous expert like Grant...