UFN_WRITEOFF_BUILDSITELIST

Returns a delimited list of sites associated with the given writeoff.

Return

Return Type
nvarchar(1024)

Parameters

Parameter	Parameter Type	Mode	Description
@WRITEOFFID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_WRITEOFF_BUILDSITELIST(
    @WRITEOFFID uniqueidentifier
)
returns nvarchar(1024)
as
begin
    declare @SITES nvarchar(1024) = (
        select dbo.UDA_BUILDLIST(NAME)
        from dbo.SITE
        where ID in(
            select DESIGNATIONLEVEL.SITEID
            from dbo.WRITEOFF
            inner join dbo.WRITEOFFSPLIT on WRITEOFFSPLIT.WRITEOFFID = WRITEOFF.ID
            inner join dbo.DESIGNATION on DESIGNATION.ID = WRITEOFFSPLIT.DESIGNATIONID
            inner join dbo.DESIGNATIONLEVEL on DESIGNATIONLEVEL.ID = coalesce(DESIGNATION.DESIGNATIONLEVEL5ID,DESIGNATION.DESIGNATIONLEVEL4ID,DESIGNATION.DESIGNATIONLEVEL3ID,DESIGNATION.DESIGNATIONLEVEL2ID,DESIGNATION.DESIGNATIONLEVEL1ID)
            where WRITEOFF.ID = @WRITEOFFID
        )
    );

    return @SITES;
end