bitwarden-server/util/Migrator/DbScripts/2023-10-21_00_User_ReadByEmails.sql

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE OR ALTER PROCEDURE [dbo].[User_ReadByEmails]
    @Emails AS [dbo].[EmailArray] READONLY
AS
BEGIN
    SET NOCOUNT ON;

    IF (SELECT COUNT(1) FROM @Emails) < 1
    BEGIN
        RETURN(-1)
    END

    SELECT
        *
    FROM
        [dbo].[UserView]
    WHERE
        [Email] IN (SELECT [Email] FROM @Emails)
END
GO