How to Execute Multiple Queries in a order

Question

I have 26 queries to generate final output I want to automate the process and Execute all 26 queries one after another

how to execute all with a single click in the stepwise order

Answer 1

This is a sample query only.

CREATE PROCEDURE Your_Procedure_Name
AS 
BEGIN

    Write your First Query;

    Write your Second Query;

    Write your Third Query;

    .
    .
    .

    Write your Last Query;

END

And then execute the procedure using:

EXEC Your_Procedure_Name;

It will execute your queries in the above order.

Answer 2

Schematic code follows:

CREATE PROCEDURE ABC

AS

BEGIN

    <query 1> ;

    <query 2> ;

    <query 3> ;

    <query 4> ;

    <query 5> ;
    :
    :
END ;

Then:

EXEC ABC ;

Hope this helps.