UFN_CONSTITUENCYSYSTEMNAME_ALLROWSEXIST
Returns whether all of the system constituencies have a row included in the CONSTITUENCYSYSTEMNAME table.
Return
| Return Type |
|---|
| bit |
Definition
Copy
CREATE function [dbo].[UFN_CONSTITUENCYSYSTEMNAME_ALLROWSEXIST]()
returns bit
as begin
if (select
count(ID)
from
dbo.CONSTITUENCYSYSTEMNAME
where
CONSTITUENCYSYSTEMNAME.ID in (
'F828E957-5F5E-479A-8F23-2FFD6C7C68FF',
'6093915E-ADE9-42BE-88AE-304731754467',
'D2DCA06A-BE6E-40B3-B95D-59A926181923',
'00E748FB-940D-4A7D-A133-C148B29410A8',
'E7489703-3D63-4017-A2BC-88C092563C5D',
'8B6ECCFD-6829-4FBC-B092-58CA083F9322',
'70165682-4324-46EC-9439-83FC0CC67E7F',
'55FE8E7C-2B68-44C8-B35C-818AD1944C03',
'C49D4B46-72A7-4206-91AA-BEABA2323E3C',
'5435C96D-8617-46C3-9A62-5AFF08451A53',
'4DB8F4FC-BC43-421D-B592-69BEF109B5FC',
'46EC3424-BA54-4431-A7DC-C6CEBB3B4592',
'2D04A9C5-27D0-4646-BF0F-6826E4C12632',
'2D11326E-8F3B-4322-9797-57C1AACFA5DF',
'3DFAC92E-78BD-4051-ABDC-02C675DEB8F6',
'CEE46FE7-3FBB-4DFE-97EB-BA67DD33C634',
'A843B859-4C6B-445B-97F3-179582E270A5',
'171AB3CD-C4E1-4825-B693-10F524A7A594',
'AC9DB5A4-14E0-416A-9FB2-04038AC66799',
'4D746A03-A0AB-45F3-A30B-1AD4F304E622',
'D9982C99-15C1-4C90-873E-56FD4B164056',
'F89E03BC-E724-4E5D-943B-72D4D1E1E916',
'908E521C-B0A5-4832-B664-7D7B079D77C2',
'093A3D4F-2974-447F-AD92-870EB4A04593',
'97688220-0AFA-4354-A327-590D715961D7',
'08D55D6A-10C8-4A72-92A0-EF87033AD7B6',
'1A9BFE80-604D-4B5B-8065-E751DDF6EF39',
'E5A0EA42-65BA-4B25-AFE2-9B709F99E72B')) = 28
return 1;
return 0;
end