USP_GET_BBISBUSINESSPROCESS_STATUS

CREATE procedure dbo.USP_GET_BBISBUSINESSPROCESS_STATUS
(
@BUSINESSPROCESSCATALOGID uniqueidentifier
)
as
begin
      select top 1 BUSINESSPROCESSCATALOGID , [STATUS], ERRORMESSAGE, NUMBEROFEXCEPTIONS , DATEADDED 
    from dbo.BUSINESSPROCESSSTATUS 
        where BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID and NUMBEROFEXCEPTIONS=0 and statusCode=0
        order by DATEADDED desc
end