Hello,

I have worked on a similar strategic initiative and utilized the following methodologies to implement the on-prem SQL Server to Data Lake to Azure SQL DW(Synapse) ETL using Azure Data...

Hello,

There are numerous Azure role based certifications that offer a great transition from traditional on-prem to Azure cloud. A few great certifications to help with this transition and learning are:

...

Hello,

The new Microsoft Certified: Azure Database Administrator Associate is great for a SQL DBA. It requires one exam to pass the certification and measures the following skills:

Plan and implement data...

Hello,

This article on logging ADF pipeline activity covers multiple methods of capturing pipeline activity details including triggerid.

https://www.mssqltips.com/sqlservertip/6320/logging-azure-data-factory-pipeline-audit-data/

Hope this helps.

Checknbr. Would be unique. I tried running the following code but was getting a "syntax error in from clause" error.

delete from RemitterSemiOutput

FROM RemitterSemiOutput a

join (

SELECT max(RemitterSemiOutput.[checknbr]) as CheckNumber, acctno,...

It appears that the cte function is not supported by access sql. Is there any other way I can phrase the code for it to successfully run in access 2007?

Thanks

I wanted to mention that this is going to be run in Access and the RemitterSemiOutput table is a table populated with data. Would this change any of the code?

Thanks