UFN_EVENTCONFLICT_GETEVENTINFO_FROMITEMLISTXML
Used to convert an xml string to a table based on UFN_EVENTCONFLICT_GETEVENTINFO.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:47:30 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Based on: UFN_EVENTCONFLICT_GETEVENTINFO
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_EVENTCONFLICT_GETEVENTINFO_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT
T.c.value('(DISTINCTLOCATIONSINCONFLICT)[1]','nvarchar(500)') AS 'DISTINCTLOCATIONSINCONFLICT',
T.c.value('(DISTINCTRESOURCESINCONFLICT)[1]','nvarchar(500)') AS 'DISTINCTRESOURCESINCONFLICT',
T.c.value('(DISTINCTSTAFFRESOURCESINCONFLICT)[1]','nvarchar(500)') AS 'DISTINCTSTAFFRESOURCESINCONFLICT',
T.c.value('(ENDDATE)[1]','datetime') AS 'ENDDATE',
T.c.value('(ENDTIME)[1]','char(4)') AS 'ENDTIME',
T.c.value('(ISLOCATIONCONFLICT)[1]','bit') AS 'ISLOCATIONCONFLICT',
T.c.value('(ISRESOURCECONFLICT)[1]','bit') AS 'ISRESOURCECONFLICT',
T.c.value('(ISSTAFFRESOURCECONFLICT)[1]','bit') AS 'ISSTAFFRESOURCECONFLICT',
T.c.value('(LOCATIONS)[1]','nvarchar(500)') AS 'LOCATIONS',
T.c.value('(LOCATIONSINCONFLICT)[1]','nvarchar(500)') AS 'LOCATIONSINCONFLICT',
T.c.value('(NAME)[1]','nvarchar(100)') AS 'NAME',
T.c.value('(PAGEID)[1]','uniqueidentifier') AS 'PAGEID',
T.c.value('(PROGRAMID)[1]','uniqueidentifier') AS 'PROGRAMID',
T.c.value('(RECORDID)[1]','uniqueidentifier') AS 'RECORDID',
T.c.value('(RECORDTYPE)[1]','tinyint') AS 'RECORDTYPE',
T.c.value('(RESOURCES)[1]','nvarchar(500)') AS 'RESOURCES',
T.c.value('(RESOURCESINCONFLICT)[1]','nvarchar(500)') AS 'RESOURCESINCONFLICT',
T.c.value('(STAFFRESOURCES)[1]','nvarchar(500)') AS 'STAFFRESOURCES',
T.c.value('(STAFFRESOURCESINCONFLICT)[1]','nvarchar(500)') AS 'STAFFRESOURCESINCONFLICT',
T.c.value('(STARTDATE)[1]','datetime') AS 'STARTDATE',
T.c.value('(STARTTIME)[1]','char(4)') AS 'STARTTIME',
T.c.value('(SUBRECORDID)[1]','uniqueidentifier') AS 'SUBRECORDID',
T.c.value('(TIMESPANDISPLAY)[1]','nvarchar(25)') AS 'TIMESPANDISPLAY'
FROM @ITEMLISTXML.nodes('/CONFLICTS/ITEM') T(c)
)