server/util/Migrator/DbScripts/2023-04-13_00_ProviderReadCountByOrganizationIds.sql

CREATE OR ALTER PROCEDURE [dbo].[ProviderOrganization_ReadCountByOrganizationIds]
    @Ids AS [dbo].[GuidIdArray] READONLY
AS
BEGIN
    SET NOCOUNT ON
        
    IF (SELECT COUNT(1) FROM @Ids) < 1
    BEGIN
        RETURN(-1)
    END
    
    SELECT
        COUNT(1)
    FROM
        [dbo].[ProviderOrganizationView]
    WHERE
        [OrganizationId] IN (SELECT [Id] FROM @Ids)
END
GO