USP_DATALIST_MAPINSTANCE

CREATE procedure dbo.USP_DATALIST_MAPINSTANCE(@MAPCATEGORYCODEID uniqueidentifier = null)
as
    set nocount on;

    select MAPINSTANCE.ID,
        MAPINSTANCE.NAME,
        MAPINSTANCE.DESCRIPTION,
        MAPCATEGORYCODE.DESCRIPTION [CATEGORY]
    from dbo.MAPINSTANCE
    left join dbo.MAPCATEGORYCODE on MAPINSTANCE.MAPCATEGORYCODEID = MAPCATEGORYCODE.ID
    where @MAPCATEGORYCODEID is null or MAPCATEGORYCODE.ID = @MAPCATEGORYCODEID;