the-biergarten-app/web/backend/Database/Database.Migrations/scripts/03-crud/05-Breweries/USP_GetBreweryById.sql

CREATE OR ALTER PROCEDURE dbo.USP_GetBreweryById @BreweryPostID UNIQUEIDENTIFIER
AS
BEGIN
    SELECT *
    FROM BreweryPost bp
             INNER JOIN BreweryPostLocation bpl
                        ON bp.BreweryPostID = bpl.BreweryPostID
    WHERE bp.BreweryPostID = @BreweryPostID;
END