search

agent86ray / SQL-AGENT-JOB-DATA-MART

This project builds a data mart from the SQL Server Agent tables. It implements an increment load design and includes type 2 slowly changing dimension handling for jobs and job steps.
1 stars 0 forks source link

Get rid of former current rows in JOB_CURRENT #19

Open agent86ray opened 3 years ago

agent86ray commented 3 years ago

Use ROW_NUMBER, partition by [job_id], [JOB_KEY] DESC Delete any row where ROW_NUMBER > 1