How do I write three select queries in a single-stored procedure in SQL Server?

 To write three SELECT queries in a single stored procedure in SQL Server, you can use the following structure. Each SELECT statement can be written one after another inside the BEGIN and END block of the stored procedure. The SELECT queries will execute sequentially when the stored procedure is called.

Here is an example of how you can do it:

CREATE PROCEDURE dbo.MyStoredProcedure
AS
BEGIN
    -- First SELECT query
    SELECT * 
    FROM Table1;

    -- Second SELECT query
    SELECT * 
    FROM Table2;

    -- Third SELECT query
    SELECT * 
    FROM Table3;
END;

Explanation:

1. Procedure Name: dbo.MyStoredProcedure is the name of the stored procedure. You can change it to whatever name you prefer.
2. SELECT Queries: The three SELECT queries are written sequentially within the BEGIN and END block.
3. Execution: When you execute this stored procedure, it will run each SELECT query in the order in which they are written. The result sets will be returned in the same order.

Example Execution:

After creating the stored procedure, you can execute it like this:

EXEC dbo.MyStoredProcedure;

This will return the result sets of all three SELECT queries, one after the other.

Important Notes:

• Each SELECT statement will return its result set to the caller.
• If you want to pass parameters or filter the results, you can add input parameters to the stored procedure and use them within your SELECT queries.
• You can also use JOIN or other SQL clauses to modify your SELECT statements as needed.

Let me know if you'd like more details on any specific part of the procedure!