@Phil Parkin When you say put the source code into the project, do you mean the dll?  They exist in the assemblies folder.  Or do you mean the actual...

You need to put the source code for the assembly into your database project. It is part of the build.

If start date is 1/1/2019 and end_date is 5/5/2019 and attended_day is Monday, which date should be used?

As you have no access to the source database and no way (in code) of identifying rows which have recently been added, modified or deleted, you are in a very...

Did you also run

EXEC sp_configure 'remote access', 1

GO 

RECONFIGURE ; 

GO

Presumably, you mean a run-time syntax error, because I see no other syntax error there?

Which specific command generates the error?

Can the select @user part of the query ever return more...

If the  question was just to convert union into join - I would have gone with full join with coalesce function -though this will not work in the view...

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...