TSQL Merge
Sources: https://docs.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-ver15
SQL WITH Common Table Expression Statement
Sources: https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver15
Run CMD Shell with TSQL
Note: By default XP_CMDSHELL is turned off, to enable XP_CMDSHELL run the following on the database server…
Execute Dynamic SQL with sp_executesql
Sources: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sql?view=sql-server-ver15
SQL For Multiple Date Type Options
For multiple date type options… and one set of date range field. 1 for Transaction Date 2 for Business Date 3 for Posted Date