server/util/Migrator/DbScripts/2025-12-03_00_ProviderUserGetManyByUserIds.sql

CREATE OR ALTER PROCEDURE [dbo].[ProviderUser_ReadManyByManyUserIds]
    @UserIds AS [dbo].[GuidIdArray] READONLY
AS
BEGIN
    SET NOCOUNT ON

    SELECT
        [pu].*
    FROM
        [dbo].[ProviderUserView] AS [pu]
    INNER JOIN
        @UserIds [u] ON [u].[Id] = [pu].[UserId]
END