I have some ideas – they involve GROUP BY and MAX(). You have nearly 4,000 points and this is simple stuff. What have you tried so far?

Please complete the following VALUES section code to give us your test data to work with:

DROP TABLE IF EXISTS #SomeTab;

CREATE TABLE #SomeTab
(
    Id INT...

Not very elegant, but I think that this works:

WITH c1
AS (SELECT *
          ,Ctr = IIF(conversion_factor IS NULL, 0,...

Here is that link again: https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Envreference should be a number, I think. Here is an example from MS:

DTExec /ISSERVER "\SSISDB\folderB\Integration Services Project17\Package.dtsx" /SERVER "." /Envreference 2 /Par "$Project::ProjectParameter(Int32)";1 /Par "Parameter(Int32)";21 /Par "CM.sqlcldb2.SSIS_repro.InitialCatalog";ssisdb...

• This reply was modified 3 years, 4 months ago by Phil Parkin.

Executing an SSIS package from T-SQL is straightforward, see link.

10-15 rules at this point...yes we would like a UI for BEU to make changes to the different rules..

Have any good examples of how to accomplish based on requirements...

This is a far better idea than mine!

I do not think that this is possible. If you check the documentation for filtered indexes (link), you will find the following limitation:

Filtered indexes are defined on one table...

Can you tell us more about the nature of the 'training platform'? Do you have direct access to a database for this platform?

Also, what do you mean by 'sent to'?...

We enabled / created SSISDB in one of our non-prod environments before we discovered we aren't allowed to use SSISDB on our servers (long story, don't ask). Now I'm...

Errors which happen as data is loaded into a physical table often result in unhelpful error messages in SSIS.

As a first step, I would try to determine one or more...

The best-practice way of doing such things is first to create and populate a generic calendar table. This could contain columns such as

Date, Year, Month, Day, Quarter, Week, MonthName, DayName

and...

This is, as I am sure you are aware, also quite heavily dependent on the...

This is, as I am sure you are aware, also quite heavily dependent on the...