USP_ADHOCQUERYDEPENDENCYBUSINESSPROCESS_GETBYID

create procedure dbo.USP_ADHOCQUERYDEPENDENCYBUSINESSPROCESS_GETBYID(@ID uniqueidentifier)
with execute as caller
as
    set nocount on;


    select IDSETREGISTERADHOCQUERY.IDSETREGISTERID,
        ADHOCQUERYDEPENDENCYBUSINESSPROCESS.NAME,
        ADHOCQUERYDEPENDENCYBUSINESSPROCESS.DESCRIPTION
    from dbo.ADHOCQUERYDEPENDENCYBUSINESSPROCESS
    left join dbo.IDSETREGISTERADHOCQUERY on ADHOCQUERYDEPENDENCYBUSINESSPROCESS.ID = IDSETREGISTERADHOCQUERY.ADHOCQUERYID 
    where ADHOCQUERYDEPENDENCYBUSINESSPROCESS.ID = @ID;