UFN_MKTCONSTITUENTFILEIMPORT_IMPORTTABLEEXISTS
Returns true if a constituent file import data table exists for a mailing.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_MKTCONSTITUENTFILEIMPORT_IMPORTTABLEEXISTS]
(
@SEGMENTATIONID uniqueidentifier
)
returns bit
as
begin
declare @CONSTITUENTFILETABLE nvarchar(256);
set @CONSTITUENTFILETABLE = dbo.[UFN_MKTCONSTITUENTFILEIMPORT_BUILDTABLENAME](@SEGMENTATIONID);
return
(
select case when exists(select 1 from INFORMATION_SCHEMA.TABLES where (TABLE_SCHEMA = 'dbo') and (TABLE_NAME = @CONSTITUENTFILETABLE)) then 1 else 0 end
);
end