I realized that I cannnot use GO inside stored procedure.

I have multiple processes where I need to drop view and then create view etc.

How do I create a stored procedure without getting error?

Basically, this is not a nested process, but process just goes from top to bottom because I am dropping views, creating views then later creating tables.

Bottom is basic structure of two processes, but I will have at least 10+ processes with similar pattern.

```
CREATE PROCEDURE Create_Views_Tables_Nov2021

AS
BEGIN
set nocount on

begin
    begin
        drop view [dbo].[vw_tblSage_GLDETAIL_0001] 
    end

begin
    CREATE VIEW [dbo].[vw_tblSage_GLDETAIL_0001]  
    AS
    SELECT *  FROM [dbo].[tblSage_GLDETAIL_1_1_Stage]
    union 
    SELECT *  FROM [dbo].[tblSage_GLDETAIL_1_2_Stage]
end

end

```