UFN_OLAPDATASOURCE_GET_BEFORE_ETL_QUEUEPROCESSID

CREATE function dbo.UFN_OLAPDATASOURCE_GET_BEFORE_ETL_QUEUEPROCESSID(@OLAPDATASOURCEID uniqueidentifier)
returns uniqueidentifier

/*
Returns the ID of a Queue Process parameter set for a queue that should run BEFORE the ETL for this data mart.
*/

as begin

    declare @QID uniqueidentifier;

    select @QID = BEFORE_ETL_QUEUEPROCESSID from dbo.OLAPDATASOURCE WHERE ID = @OLAPDATASOURCEID;    

    return @QID;

end