UFN_ADHOCQUERY_FIELDISINUSE

Return

Return Type
bit
Parameters

Parameter	Parameter Type	Mode	Description
@OBJECT	nvarchar(255)	IN
@COLUMN	nvarchar(255)	IN
Definition

Copy


                create function dbo.UFN_ADHOCQUERY_FIELDISINUSE(@OBJECT nvarchar(255), @COLUMN nvarchar(255))
                returns bit
                as 
                begin
                    if exists(select 1 from dbo.ADHOCQUERY 
                                        where ADHOCQUERY.QUERYDEFINITIONXML.exist('declare namespace ns="Blackbaud.AppFx.WebService.API.1";
                                                                                                                            ns:AdHocQuery/*/ns:f[@ObjectName=sql:variable("@OBJECT") 
                                                                                                                            and (@ColumnName=sql:variable("@COLUMN") or sql:variable("@COLUMN") = '''')]') = 1)
                    begin
                        return 1;
                    end

                    return 0;
                end