UFN_ANALYTICSMODEL_GETANALYTICSMODELS_TOITEMLISTXML

Return

Return Type
xml

Definition

Copy
/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:33:59 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_ANALYTICSMODEL_GETANALYTICSMODELS
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_ANALYTICSMODEL_GETANALYTICSMODELS_TOITEMLISTXML](
    )
returns xml
as
BEGIN

RETURN (
 SELECT 
  [ID] as [@ID],
  [NAME] as [@NAME],
  [SCORECATEGORYMAX] as [@SCORECATEGORYMAX],
  [SCORECATEGORYMIN] as [@SCORECATEGORYMIN]
 FROM dbo.[UFN_ANALYTICSMODEL_GETANALYTICSMODELS]()
 order by NAME
 for xml path('ITEM'),type,elements,root('ANALYTICSMODELS'),BINARY BASE64

)

END