UFN_DATALIST_ISSUMMARYFIELD
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALISTSPECXML | xml | IN | |
| @FIELDID | nvarchar(200) | IN |
Definition
Copy
create function dbo.UFN_DATALIST_ISSUMMARYFIELD
(
@DATALISTSPECXML as xml,
@FIELDID as nvarchar(200)
)
returns bit
as
begin
declare @b bit;
with xmlnamespaces ('bb_appfx_datalist' as tns, 'bb_appfx_commontypes' as common)
select @b = @DATALISTSPECXML.exist('tns:DataListSpec/tns:Parameters/tns:SummaryFields/tns:SummaryFieldID[text() = sql:variable("@FIELDID")]');
return @b;
end