I think this better to do step by step first get all custno into temp table and groupid then updating each found, you know way way better you have seen...

So my question is how can I add these nuget/dll files into ".SSISDeploymentManifest" and install them automatically when I am deploying the package?

As far as I know, you cannot. Adding the assembly...

Your rules are too complex to do this in a single query. Instead, I suggest that you build up the groups one at a time, with one query for every...

I don't think you answered this question:

Can the same customer be in more than one group?

This is a very likely scenario if all of the rules are always applied to...

Also, are the rules you mentioned to be applied in the order they are written, such that if a customer gets assigned to group X, they cannot subsequently also be...

Regarding your expected results, are you hoping for (GroupId, CustNo)?

In what form are the 99 serial numbers? Are they in a table?

Can you craft a SELECT statement which produces the rows you wish to insert? If yes, the rest is easy:

INSERT table (column list)
SELECT column list FROM ...

Here's an example. Get cutting and pasting and the rest of the columns are done.

DROP TABLE IF EXISTS #UnitProdFinal;

CREATE TABLE #UnitProdFinal
(
    YearMonth INT NULL
...

Perhaps 'randomly' is not wholly...

This should do it:

string fileDate = "2024-03-31";
 
DateTime someDate = DateTime.ParseExact(fileDate, "yyyy-MM-dd", CultureInfo.InvariantCulture);

• This reply was modified 1 year, 5 months ago by Phil Parkin.

Obviously a hierarchy of some sort. What sort of data do the rows in the table represent?

Did you refresh the Intellisense local cache? CTRL-SHIFT R

Never heard it called Abscess before!

• This reply was modified 1 year, 5 months ago by Phil Parkin.

Please clarify what you mean by this:

incremental time of the transaction day.

What is that, and how does it differ from 'time'?

… Or of...