SELECT Max(Careplan_ID)+1 AS pCareplan_ID FROM #Request.prefix_db_agency#.pCareplan
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status = 0
INSERT INTO #Request.prefix_db_agency#.pCareplan
(
Careplan_ID, Assmt_ID, Item_ID, Order_ID, Status, Skill,
Type, Description, other, Notes,Date_Target , Date_Create,
Created_by, Date_Change, Change_by
)
VALUES
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
SELECT * FROM #Request.prefix_db_agency#.pAssessments
WHERE Assmt_ID =
AND status = 0