USP_DATALIST_PAGE_MODEL_DESIGN

CREATE procedure dbo.USP_DATALIST_PAGE_MODEL_DESIGN(
      @CLIENTSITESID int = null,
      @RECORDID uniqueidentifier = null,
      @MODELID uniqueidentifier = null
)
as
    set nocount on;

    select 
        PAGEMODELDESIGN.[ID],
        PAGEMODELDESIGN.[MODELNAME],
        PAGEMODELDESIGN.[CLIENTSITESID],
        PAGEMODELDESIGN.[ARTIFACTPREFIX],
        PAGEMODELDESIGN.[LOCKARTIFACTS],
        PAGEMODELDESIGN.[MODELID],
        PAGEMODELDESIGN.[EXPORTOPTIONS]        
    from 
        dbo.PAGEMODELDESIGN
  where 
        ID=@RECORDID 
        or
        (CLIENTSITESID=@CLIENTSITESID
        and
        @RECORDID is null
        and 
        @MODELID is null)
        or
        (CLIENTSITESID=@CLIENTSITESID
        and 
        MODELID=@MODELID
        and
        @RECORDID is null)