USP_DATALIST_GETMETADATA

CREATE procedure [dbo].[USP_DATALIST_GETMETADATA]
    @ID uniqueidentifier
as
    select 
        DLC.DATALISTSPEC AS SPECXML,
        DLC.IMPLEMENTATIONTYPE,
        DLC.RECORDTYPEID,
        DLC.DATECHANGED,
        DLC.TSLONG,
        cast(case when P.SPECIFIC_SCHEMA is null then 0 else 1 end as bit) as HASAPPUSER,
        cast(case when P2.SPECIFIC_SCHEMA is null then 0 else 1 end as bit) as HASMAXROWS

    from 
        dbo.DATALISTCATALOG DLC
        left outer join INFORMATION_SCHEMA.PARAMETERS P on P.SPECIFIC_SCHEMA='dbo' and P.SPECIFIC_NAME = DLC.PROCEDURENAME and P.PARAMETER_NAME = '@CURRENTAPPUSERID'
        left outer join INFORMATION_SCHEMA.PARAMETERS P2 on P2.SPECIFIC_SCHEMA='dbo' and P2.SPECIFIC_NAME = DLC.PROCEDURENAME and P2.PARAMETER_NAME = '@MAXROWS'
    where DLC.ID = @ID;

    return 0;