SELECT * FROM #Request.prefix_db_agency#.#teach_sk# WHERE Patient_ID= AND Assmt_ID= AND ICD= AND Pathway_Type= AND Pathway_ID <> 0 AND Deleted=0 SELECT * FROM #Request.prefix_db_lookup#.CW_Coding_Class_PDGM as cw JOIN #Request.prefix_db_lookup#.vetted_190924 as vt ON vt.Priority = cw.Priority WHERE vt.Pathway = cw.Pathway_ID AND vt.ICD = SELECT * FROM #Request.prefix_db_lookup#.#teach_prev# WHERE Pathway_ID= ORDER BY Step_ID ASC INSERT INTO #Request.prefix_db_agency#.#teach_sk# ( Patient_ID, Assmt_ID, ICD, 3Digit, Pathway_Type, Pathway_ID, Step_ID, Line_ID, Explanation, Created_Date, Created_by, Updated_Date, Updated_by, Diagnosis_ID, `Order_ID`, Title_Order_ID ) VALUES ( , , , , , , , , , , , , , , , ) SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE Assmt_ID= AND Problem_ID = AND Status = 0 SELECT * FROM #Request.prefix_db_lookup#.#teach_sym# WHERE Priority = '#Priority#' ORDER BY Step_ID ASC INSERT INTO #Request.prefix_db_agency#.#teach_sk# ( Patient_ID, Assmt_ID, ICD, 3Digit, Pathway_Type, Pathway_ID, Step_ID, Line_ID, Explanation, Created_Date, Created_by, Updated_Date, Updated_by, Diagnosis_ID, Order_ID, Title_Order_ID ) VALUES ( , , , , , , , , , , , , , , , )