Hi there,
Anyone pls suggest why I am getting an error like below:
My Sp script is like below :
USE DB
Create PROCEDURE [dbo].[sp_MakeFact] AS
SET NOCOUNT ON;
DROP TABLE IF EXISTS AmberCare;
WITH AmberCare AS (
select * from table)
SELECT
AmberCare.[FACILITY]
,AmberCare.[MRN]
,AmberCare.[AUID]
,1 as Measure_AmberCare
,0 as Measure_Advancecare
INTO final_table
FROM AmberCare
LEFT JOIN
[APU_BI].[dbo].[VIEW_EPISODE_MASTER] EM
ON EM.stay_number = AmberCare.visit_id
AND EM.facility_identifier = AmberCare.Facility_identifier;
DROP TABLE IF EXISTS Advancecare;
WITH AmberCare AS (
select * from table)
SELECT
AdvanceCare.[FACILITY]
,AdvanceCare.[MRN]
,AdvanceCare.[AUID]
,0 as Measure_Ambercare
,1 as Measure_Advancecare
INTO final_table
FROM Advancecare
LEFT JOIN
[VIEW] EM
ON EM.stay_number = Advancecare.visit_id
AND EM.facility_identifier = Advancecare.Facility_identifier
AND ADVANCE_CARE_DIRECTIVE='YES';
when exec the sp I am getting below error:
