UFN_GET_BACKUPITEMVALUENODE_BY_KEYGUID

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@KEYGUID	uniqueidentifier	IN
@KeyName	nvarchar(100)	IN

Definition

Copy



create function dbo.UFN_GET_BACKUPITEMVALUENODE_BY_KEYGUID
(
@KEYGUID uniqueidentifier,
@KeyName nvarchar(100)
)
returns bit
as begin

                DECLARE @value bit;
                select @value = CASE  WHEN X.Y.value('(Value)[1]', 'nvarchar(100)') = 'false' then 0 else 1 end    
        from CMS_SESSIONVARIABLEBACKUP e
        OUTER APPLY e.DATA.nodes('ArrayOfBackUpItem/BackUpItem') as X(Y)
        where e.KEYGUID = @KEYGUID
        and X.Y.value('(Key)[1]', 'nvarchar(100)') = @KeyName

                RETURN @value;
end