you need to use the output clause

With ProductName(ProductID, Description)
AS
(

    SELECT ProductID, ProductName
    FROM dbo.Products

)


INSERT INTO ProductName     ...

Having said this in my shop some of the teams do do some level of code review - and...

ahhhh... who will code review my SP with 10k lines ..

• This reply was modified 5 years, 8 months ago by frederico_fonseca.

could be a bug - but it is also how ADR / PVS works.

look at the troubleshooting section of https://docs.microsoft.com/en-us/sql/relational-databases/accelerated-database-recovery-management?view=sql-server-ver15 - DMV's will probably help you determine what is causing...

you will need mapping tables for sure - with source ids and new id's

how many will depend on your system.

so initial migration step is to do the "base" tables e.g....

if both use the same ERP system maybe the vendor has a tool that will "merge" both into a single instance - have you contacted them about it?

And not all...

what have you googled and what have you found out that you didn't understand?

plenty of info out there and we are not here to do the search for you.

and out of curiosity why are you still using something that requires you to connect to Integration Services? in 2016 you should be using SSIS Catalog which does not require...

https://www.ibm.com/support/pages/informix-client-software-development-kit-client-sdk-and-informix-connect-system-requirements?mhsrc=ibmsearch_a&mhq=informix%20client%20sdk

but I think you need a login - possibly under the contract your company has for Informix

or you may be able to use a third party driver - possibly https://www.progress.com/odbc/ibm-informix

you need to understand how filtering can be done - and the order it happens. and the difference between being a inner or a outer join

• Join - indicates how...

you don't have any filtering on #SOURCETABLE - you only filter on the join, so all records from #SOURCETABLE  will be selected.

and the only record you have on the sample...

according to documentation it would seem that it does not but worth confirming with someone that does work with PDW

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/database-mail-stored-procedures-transact-sql?view=sql-server-ver15

sysadmin is server (instance) level role as seen on

description of what each column for syslogins below

https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-syslogins-transact-sql?view=sql-server-ver15

and as you will need it for sure https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/server-and-database-roles-in-sql-server

Ideally you would load the events onto a sql server table and do the analysis and initial filtering there - easier with high volumes.

sample example that I use to do...

then don't commit the username/password - that could be on a "do not commit" file on your machine and get BIML to retrieve the username/password part from that file