SELECT pProgress.*,pSchedules.Visit_Date FROM #Request.prefix_db_agency#.pProgress
JOIN #Request.prefix_db_agency#.pSchedules ON pSchedules.Schedule_ID = pProgress.Schedule_ID AND pSchedules.Status = 0
WHERE pProgress.Description =
AND pProgress.status = 0
AND pSchedules.Patient_ID =
AND pSchedules.Skill =
GROUP BY pProgress.Progress_ID
ORDER BY pSchedules.Visit_Date ASC
#Dateformat(Visit_Date,"mm/dd/yyyy")#
#Notes#
UPDATE #Request.prefix_db_agency#.pSchedules SET
goals_not_met = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID =
AND status = 0
UPDATE #Request.prefix_db_agency#.pSchedules SET
unstable_action = ,
Date_Change = ,
Change_by =
WHERE Schedule_ID =
AND status = 0
SELECT IFNULL(MAX(Schedule_ID),0)+1 As pSchedule_ID FROM #Request.prefix_db_agency#.pSchedules
SELECT * FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID =
AND Status = 0 ORDER BY AutoSchedule_ID DESC
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME NOT IN ('AutoSchedule_ID','record_timestamp')
AND TABLE_SCHEMA='#Request.prefix_db_agency#' AND TABLE_NAME = 'pSchedules';
INSERT INTO #Request.prefix_db_agency#.pSchedules
(#myList#)
SELECT #myList# FROM #Request.prefix_db_agency#.pSchedules
WHERE Schedule_ID =
AND Status = 0
AND AutoSchedule_ID = '#getold.AutoSchedule_ID#'
SELECT LAST_INSERT_ID() as LastInsertID
UPDATE #Request.prefix_db_agency#.pSchedules SET
Status = ,
Date_Create = ,
Created_by = ,
Date_Change = ,
Change_by =
WHERE AutoSchedule_ID =
Update #Request.prefix_db_agency#.pSchedules
Set Status = ,
Date_Change = ,
Change_by =
WHERE AutoSchedule_ID = '#getold.AutoSchedule_ID#'
SELECT * FROM #Request.prefix_db_agency#.pCareplan
WHERE Careplan_ID =
AND Status = 0 ORDER BY AutoCareplan_ID DESC
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME NOT IN ('AutoCareplan_ID','record_timestamp')
AND TABLE_SCHEMA='#Request.prefix_db_agency#' AND TABLE_NAME = 'pCareplan';
INSERT INTO #Request.prefix_db_agency#.pCareplan
(#myList#)
SELECT #myList# FROM #Request.prefix_db_agency#.pCareplan
WHERE Careplan_ID =
AND Status = 0
SELECT LAST_INSERT_ID() as LastInsertID
UPDATE #Request.prefix_db_agency#.pCareplan SET
Status = ,
Date_Change = ,
Change_by =
WHERE AutoCareplan_ID =
Update #Request.prefix_db_agency#.pCareplan
Set Status = ,
Date_Change = ,
Change_by =
WHERE AutoCareplan_ID = '#getold.AutoCareplan_ID#'
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Status = 0 ORDER BY AutoAssmt_ID DESC
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME NOT IN ('AutoAssmt_ID','record_timestamp')
AND TABLE_SCHEMA='#Request.prefix_db_agency#' AND TABLE_NAME = 'pAssessments';
INSERT INTO #Request.prefix_db_agency#.pAssessments
(#myList#)
SELECT #myList# FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND Status = 0
SELECT LAST_INSERT_ID() as LastInsertID
UPDATE #Request.prefix_db_agency#.pAssessments SET
Status = ,
Record_Creation_Date = ,
Record_Created_By = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE AutoAssmt_ID =
Update #Request.prefix_db_agency#.pAssessments
Set Status = ,
Record_Mod_Date = ,
Record_Mod_By =
WHERE AutoAssmt_ID = '#getold.AutoAssmt_ID#'
SELECT * FROM #Request.prefix_db_agency#.pProblem
WHERE Problem_ID =
AND Status = 0 ORDER BY AutoProblem_ID DESC
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME NOT IN ('AutoProblem_ID','record_timestamp','manual')
AND TABLE_SCHEMA='#Request.prefix_db_agency#' AND TABLE_NAME = 'pProblem';
INSERT INTO #Request.prefix_db_agency#.pProblem
(#myList#)
SELECT #myList# FROM #Request.prefix_db_agency#.pProblem
WHERE Problem_ID =
AND Status = 0
GROUP BY Problem_ID
SELECT LAST_INSERT_ID() as LastInsertID
UPDATE #Request.prefix_db_agency#.pProblem SET
Status = ,
Date_Change = ,
Change_by =
WHERE AutoProblem_ID =
Update #Request.prefix_db_agency#.pProblem
Set Status = ,
Date_Change = ,
Change_by =
WHERE AutoProblem_ID !=
AND Problem_ID =
AND Status = 0