IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'macroProcedures'
      AND Object_ID = Object_ID(N'pal_MedicalProcedure'))
BEGIN
    ALTER TABLE pal_MedicalProcedure
	ADD macroProcedures VARCHAR(max); 
END



IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'procedureQty'
      AND Object_ID = Object_ID(N'pal_MedicalPatientProcedureBooking'))
BEGIN
    ALTER TABLE pal_MedicalPatientProcedureBooking
	ADD procedureQty int; 
END