No, it will be one-to-many in most cases.  For some of these files, only the MD5 has was generated, but for others the SHA1 and PhotoDNA hashes were also...

So the link is from Hashes(MediaId) to Media(Id), is that correct?

If so, is this a one-to-one relationship?

If so, I don't see a lot of point in having it as a...

Some sort of MERGE will probably do the trick.

What is the relationship between the import table and the other two?

That is, exactly how do you determine from one imported row...

My SSIS debugging seems to be different from most.

In the Control Flow, you can set breakpoints on any object, which can kick in at different points (before execute, after execute...

Print etc as others but I've fallen in love with CTEs (Common Table Expressions) and use them a lot now, especially to build up complex queries or those with...

What would you insert if there are multiple source rows with the same Id? For example

id   value

2    20

2    30

Would this require two inserts of 20 and 30, or...

Please refer to answers in your previous, near-identical, thread.

You may be interested to read...

Heh, Phil's name is not, nor ever has been, Sean! And the query was deliberately written in that way, as the OP did not specify the need to...

Sure, you can break down the merge into its constituent INSERTs, UPDATEs and DELETEs.

Once you have done that, you will be in a better position to work out which statement(s)...

This is one way.

DROP TABLE IF EXISTS #SomeTable;

CREATE TABLE #SomeTable
(
    Col1 VARCHAR(5)
   ,Col2 VARCHAR(5)
   ,Col3 VARCHAR(5)
   ,Col4 VARCHAR(5)
);

INSERT...

I started watching a YouTube video on Azure DevOps. I can't have the sound turned up where I am, so I turned on subtitles. This is as far as I...

Heh, Phil's name is not, nor ever has been, Sean!

And the query was deliberately written in that way, as the OP did not specify the need to see aggregated results...

What makes you think that this is a memory leak?

SELECT [13latam] = IIF(rc.TYear = 13 AND rc.Region = 'Latam', rc.RowCnt, NULL)
      ,[14latam] = IIF(rc.TYear = 14 AND rc.Region = 'Latam', rc.RowCnt,...