Sorry - substring is SQL and the corresponding function in SSRS would be MID.

=MID(IIF(Fields!OpeningDate.Value = 1, ", Opening Date", "") &
      ...

@JeffModen - that would be great, except most don't even know what character 7 let alone 28 through 31 are or how they were used.  Or why we used CR...

As I started down the path of re-clustering the PK.

UNIQUEly CLUSTERED on ( Quality_Date, Quality_ID ).

Quality_Date is a computed column and set to NULL  which can't be part of...

So it sounds like you want to adjust it to return the string minus the last character.

I would use a combination of LEFT and LEN (not 100% sure on...

Is there any way you could show the data flow task - with the source/destination and the column mappings?  Assuming that is the way you are moving the data from...

Now that I think about this - you don't actually need a dynamic cross-tab.  Because you want this output to an html email - the FOR XML code will dynamically...

Thank you for your input. This is a true air gapped system/network and connection is strictly limited to machines on that network. Opening it up to external access, no...

It would help if we could see the code you are using - and any error messages.  I use WinSCP to upload files within an SSIS package - and use...

I would approach this differently - I would create a powershell script that removes the empty directories and schedule that to run using the powershell subsystem in SQL Server agent,...

Another approach is to populate local tables with the previous day/month/year of data.  In most cases - the queries don't need real-time up to the second data, so those can...

To get the results - you need to use GROUP BY with GROUPING SETS and GROUPING_ID.  There are plenty of examples in BOL to show how that can be done. ...

https://www.sqlservercentral.com/forums/topic/create-html-email#post-3889947

Maybe this will give you some ideas:

        Backup Database @database 
         ...

Please provide a sample set of data and expected results.  The 'data' you provided doesn't tell us what the div column is - or how to interpret what data needs...

To process this data I setup Sql Agent jobs and basically setup one for each oven\wireline. It's processing the queue of records fairly fast but I do see a...