Exporting from SQL to XML issue

Question

Post reply

Exporting from SQL to XML issue

Jobs90312

Mr or Mrs. 500

Points: 533
More actions
November 29, 2022 at 6:08 am
Go to Answer
#4119322
Hi everyone,
So I have a table which consists of different IDs of a person. Like for example their national id card no, and passport and NTN no etc

I have to convert this table into XML format so it would look like this:

But I am getting the result like this in two separate tags of National Identity:
This is my code:
```
SELECT
('CNIC') as ID_TYPE_01,
(SELECT COALESCE([NatID_Num],'') WHERE NatID_Type = 'CNIC') as ID_NUMBER_01,
('PASSPORT') as ID_TYPE_02,
(SELECT COALESCE([NatID_Num],'') WHERE NatID_Type = 'PASSPORT') as ID_NUMBER_02,
('NTN') as ID_TYPE_03,
(SELECT COALESCE([NatID_Num],'') WHERE NatID_Type = 'NTN') as ID_NUMBER_03
FROM National_Identity NIz
WHERE 
Active = 1
and
NatId_Record_ID_FK = 'FIA-001299'
FOR XML PATH('National_Identity'),
ELEMENTS XSINIL,
type
```
- This topic was modified 1 year, 11 months ago by Jobs90312.
- This topic was modified 1 year, 11 months ago by Jobs90312.

Mark Cowne

One Orange Chip

Points: 26952

November 30, 2022 at 11:23 am

Answer

#4119985

Use ISNULL

SELECT ISNULL(
(SELECT 'CNIC' as ID_TYPE_01,
       MAX(CASE WHEN NatID_Type = 'CNIC' THEN NatID_Num END) AS ID_NUMBER_01,
   'PASSPORT' as ID_TYPE_02,
       MAX(CASE WHEN NatID_Type = 'PASSPORT' THEN NatID_Num END) AS ID_NUMBER_02,
   'NTN' as ID_TYPE_03,
       MAX(CASE WHEN NatID_Type = 'NTN' THEN NatID_Num END) AS ID_NUMBER_03
FROM National_Identity
WHERE 
Active = 1
and
NatId_Record_ID_FK = 'xxxFIA-001299'
GROUP BY NatId_Record_ID_FK
FOR XML PATH('National_Identity'), ROOT('National_Identities'),TYPE),'<National_Identities/>');

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32345 More actions · Answer 1

If I run your code I get

Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@listid".

Is it possible to have some sample data in an easy consumable format?

Script of table + some insert statements

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 2

We will need your help in order to be able to help you, so please help us!

😎

It would be greatly appreciated if you could provide the DDL (create table) script, sample data as an insert statement, the desired output from the sample data, and what you have tried so far.

Jobs90312 Mr or Mrs. 500 Points: 533 More actions · Answer 3

Jo Pattyn wrote:

If I run your code I get
Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@listid".
Is it possible to have some sample data in an easy consumable format?
Script of table + some insert statements

Here you go. I have also modified my code and removed the WHERE clause settings so you can run the query...

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[National_Identity](
[NatId_PK] [int] IDENTITY(1,1) NOT NULL,
[NatID_Type] [nvarchar](100) NULL,
[NatID_Num] [nvarchar](500) NULL,
[NatID_issue] [date] NULL,
[NatID_expiry] [date] NULL,
[NatID_State_Province] [nvarchar](100) NULL,
[NatID_Country] [nvarchar](100) NULL,
[isNationality] [nvarchar](100) NULL,
[Soft_Delete] [nvarchar](1) NULL,
[Date_of_Soft_Delete] [date] NULL,
[NatId_Record_ID_FK] [nvarchar](100) NULL,
[NatId_UniqueID_FK] [int] NULL,
[File_Names] [nvarchar](450) NULL,
[National_Identities_Id] [nvarchar](100) NULL,
[Individual_List_ID_FK] [int] NULL,
[Active] [int] NULL,
[Active_Inactive_Reason] [nvarchar](100) NULL,
[Other_Info] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[National_Identity] ON 

INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (408, N'CNIC', N'820187667057', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000985', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (409, N'CNIC', N'3630368797483', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000986', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (410, N'CNIC', N'3310587869077', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000987', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (411, N'CNIC', N'3520122401189', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000988', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (412, N'CNIC', N'3640290600519', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000989', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (413, N'CNIC', N'3550403749067', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000990', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (414, N'CNIC', N'1210167327577', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000991', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (415, N'CNIC', N'3310007708639', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000992', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (416, N'CNIC', N'3440106116666', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000994', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (417, N'CNIC', N'3710361687299', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000995', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (418, N'CNIC', N'3830298907109', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000996', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (419, N'CNIC', N'3830210665607', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000997', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (420, N'CNIC', N'520286078341', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000998', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (421, N'CNIC', N'3520227628599', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-000999', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (422, N'CNIC', N'3840351816041', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001000', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (423, N'CNIC', N'3130134831521', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001004', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (424, N'CNIC', N'1730139771257', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001006', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (425, N'CNIC', N'4200090686073', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001007', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (426, N'CNIC', N'3840341024255', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001008', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (427, N'CNIC', N'4220150177951', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001009', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (428, N'CNIC', N'3710409796929', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001010', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (429, N'CNIC', N'3720123767807', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001011', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (430, N'CNIC', N'3510125140989', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001012', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (431, N'PASSPORT', N'KG702946', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001012', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (432, N'CNIC', N'3130358033731', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001013', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (433, N'CNIC', N'3630235436785', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001014', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (434, N'CNIC', N'3520039148675', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001015', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (435, N'CNIC', N'3220301141537', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001018', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (436, N'CNIC', N'4220134321805', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001019', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (437, N'CNIC', N'3630218674695', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001023', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (438, N'CNIC', N'3740585380283', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001024', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (439, N'CNIC', N'3540143823989', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001025', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (440, N'CNIC', N'3320212706833', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001026', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (441, N'PASSPORT', N'AE1916832', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001026', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (442, N'CNIC', N'3460322399235', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001027', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (443, N'CNIC', N'3510131753285', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001028', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (444, N'CNIC', N'3640247707495', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001030', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (445, N'CNIC', N'1210146634367', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001031', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (446, N'CNIC', N'8130196528389', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001032', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (447, N'CNIC', N'8130145488849', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001033', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (448, N'CNIC', N'3520286889597', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001035', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (449, N'CNIC', N'9100501055965', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001039', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (450, N'CNIC', N'31566205607', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001046', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (451, N'CNIC', N'23389184093', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001047', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (452, N'CNIC', N'4210153749473', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001051', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (453, N'CNIC', N'3810299414481', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001052', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (454, N'CNIC', N'3320209375865', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001053', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (455, N'CNIC', N'4240176554105', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001072', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (456, N'CNIC', N'1410190212105', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001081', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (457, N'CNIC', N'4330258996439', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001082', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (458, N'CNIC', N'4250193435005', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001083', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (459, N'CNIC', N'5510274742539', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001134', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (460, N'CNIC', N'5510318728995', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001135', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (461, N'CNIC', N'5510318728493', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001136', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (462, N'CNIC', N'5110215990387', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001153', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (463, N'CNIC', N'7120224908909', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001187', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (464, N'CNIC', N'712021645617', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001188', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (465, N'CNIC', N'7120251179313', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001189', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (466, N'CNIC', N'120290694651', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001191', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (467, N'CNIC', N'712021155861', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001192', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (468, N'CNIC', N'7120214699701', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001193', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (469, N'CNIC', N'7150109302869', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001196', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (470, N'CNIC', N'7120343283831', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001198', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (471, N'CNIC', N'7150176885683', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001199', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (472, N'CNIC', N'1730175234063', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001200', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (473, N'CNIC', N'7120265740423', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001202', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (474, N'CNIC', N'5440037301685', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001229', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (475, N'CNIC', N'5440196218885', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001231', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (476, N'CNIC', N'5440154050121', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001232', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (477, N'CNIC', N'5420318753645', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001233', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (478, N'CNIC', N'5650323674451', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001234', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (479, N'CNIC', N'5430301803751', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001235', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (480, N'CNIC', N'5440193553307', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001252', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (481, N'CNIC', N'5410289719487', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001253', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (482, N'CNIC', N'5410292977337', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001254', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (483, N'CNIC', N'5440107109737', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001255', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (484, N'CNIC', N'5440043325185', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001260', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (485, N'CNIC', N'5440093481709', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001261', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (486, N'CNIC', N'3520289564816', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001262', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (487, N'PASSPORT', N'BE7794811', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001262', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (488, N'CNIC', N'3520256520973', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001263', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (489, N'PASSPORT', N'CX1010972', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001263', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (490, N'CNIC', N'3840330561049', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001264', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (491, N'PASSPORT', N'UB1151042', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001264', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (492, N'CNIC', N'3310252930057', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001265', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (493, N'CNIC', N'3520179788195', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001266', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (494, N'PASSPORT', N'BD1888192', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001266', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (495, N'CNIC', N'4200004544293', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001267', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (496, N'PASSPORT', N'BD1888192', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001267', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (497, N'CNIC', N'3530188087687', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001268', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (498, N'PASSPORT', N'TS4117682', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001268', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (499, N'CNIC', N'3520296045337', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001269', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (500, N'PASSPORT', N'XY1155331', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001269', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (501, N'CNIC', N'3310584413937', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001270', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (502, N'PASSPORT', N'BD1888192', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001270', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (503, N'CNIC', N'1730116830545', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001271', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (504, N'PASSPORT', N'MV1010541', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001271', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (505, N'CNIC', N'3310250094661', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001272', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (506, N'CNIC', N'3320164727151', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001273', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
GO
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (507, N'PASSPORT', N'TB6897152', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001273', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (508, N'CNIC', N'3520222692655', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001274', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (509, N'PASSPORT', N'DG9912651', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001274', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (510, N'CNIC', N'3650213637281', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001275', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (511, N'PASSPORT', N'BG1227282', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001275', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (512, N'CNIC', N'3630203150879', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001276', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (513, N'CNIC', N'3310051708049', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001277', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (514, N'CNIC', N'3840536620347', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001278', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (515, N'PASSPORT', N'RK1810341', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001278', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (516, N'CNIC', N'3320289043275', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001279', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (517, N'CNIC', N'3310089504799', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001280', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (518, N'PASSPORT', N'BN0844792', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001280', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (519, N'CNIC', N'3460180155295', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001281', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (520, N'PASSPORT', N'AK-5465292', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001281', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (521, N'CNIC', N'3420103033741', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001282', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (522, N'PASSPORT', N'HG1333743', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001282', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (523, N'CNIC', N'3460192685341', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001283', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (524, N'PASSPORT', N'MS6895342', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001283', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (525, N'CNIC', N'3740166794195', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001284', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (526, N'PASSPORT', N'KH-140099', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001284', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (527, N'CNIC', N'3740503709371', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001285', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (528, N'PASSPORT', N'BW-0159371', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001285', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (529, N'CNIC', N'3460156274065', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001287', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (530, N'PASSPORT', N'AC9794063', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001287', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (531, N'CNIC', N'3410175270957', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001289', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (532, N'PASSPORT', N'FC6891813', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001289', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (533, N'CNIC', N'3420199082671', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001290', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (534, N'PASSPORT', N'BJ6892672', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001290', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (535, N'CNIC', N'3710197964953', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001291', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (536, N'CNIC', N'3440370072107', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001292', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (537, N'PASSPORT', N'BK0722101', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001292', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (538, N'CNIC', N'3420245503233', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001293', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (539, N'PASSPORT', N'BE4793233', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001293', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (540, N'CNIC', N'3130156384029', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001294', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (541, N'PASSPORT', N'AJ0344023', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001294', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (542, N'CNIC', N'3620105584727', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001295', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (543, N'PASSPORT', N'AJ0344023', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001295', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (544, N'CNIC', N'3240339175351', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001296', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (545, N'PASSPORT', N'BE6915352', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001296', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (546, N'CNIC', N'3650184327515', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001297', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (547, N'PASSPORT', N'EU0847511', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001297', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (548, N'CNIC', N'3660309149009', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001298', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (549, N'PASSPORT', N'EK5759001', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001298', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (550, N'CNIC', N'3740565859119', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001299', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)
INSERT [dbo].[National_Identity] ([NatId_PK], [NatID_Type], [NatID_Num], [NatID_issue], [NatID_expiry], [NatID_State_Province], [NatID_Country], [isNationality], [Soft_Delete], [Date_of_Soft_Delete], [NatId_Record_ID_FK], [NatId_UniqueID_FK], [File_Names], [National_Identities_Id], [Individual_List_ID_FK], [Active], [Active_Inactive_Reason], [Other_Info]) VALUES (551, N'PASSPORT', N'AP-9599112', NULL, NULL, NULL, NULL, NULL, N'N', NULL, N'FIA-001299', NULL, N'FPMAMLCHECK-FIA-11-5-2022.xlsx', NULL, 4, 1, NULL, NULL)

SET IDENTITY_INSERT [dbo].[National_Identity] OFF
GO

This reply was modified 1 year, 11 months ago by Jobs90312.
This reply was modified 1 year, 11 months ago by Jobs90312.

Mark Cowne One Orange Chip Points: 26952 More actions · Answer 4

This should work for you

SELECT 'CNIC' as ID_TYPE_01,
       MAX(CASE WHEN NatID_Type = 'CNIC' THEN NatID_Num END) AS ID_NUMBER_01,
   'PASSPORT' as ID_TYPE_02,
       MAX(CASE WHEN NatID_Type = 'PASSPORT' THEN NatID_Num END) AS ID_NUMBER_02,
   'NTN' as ID_TYPE_03,
       MAX(CASE WHEN NatID_Type = 'NTN' THEN NatID_Num END) AS ID_NUMBER_03
FROM National_Identity
WHERE 
Active = 1
and
NatId_Record_ID_FK = 'FIA-001299'
GROUP BY NatId_Record_ID_FK
FOR XML PATH('National_Identity'), ROOT('National_Identities'),ELEMENTS XSINIL,TYPE

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537

Jobs90312 Mr or Mrs. 500 Points: 533 More actions · Answer 5

Mark Cowne wrote:

This should work for you

SELECT 'CNIC' as ID_TYPE_01,
       MAX(CASE WHEN NatID_Type = 'CNIC' THEN NatID_Num END) AS ID_NUMBER_01,
   'PASSPORT' as ID_TYPE_02,
       MAX(CASE WHEN NatID_Type = 'PASSPORT' THEN NatID_Num END) AS ID_NUMBER_02,
   'NTN' as ID_TYPE_03,
       MAX(CASE WHEN NatID_Type = 'NTN' THEN NatID_Num END) AS ID_NUMBER_03
FROM National_Identity
WHERE 
Active = 1
and
NatId_Record_ID_FK = 'FIA-001299'
GROUP BY NatId_Record_ID_FK
FOR XML PATH('National_Identity'), ROOT('National_Identities'),ELEMENTS XSINIL,TYPE

I can work with this but there is something else I am looking for also.

If for example in WHERE clause (NatId_Record_ID_FK = 'FIA-001299') if I enter a record id which is not present in the table, it is showing result = NULL.

Is there anyway to modify the query that in case a certain record is not present it should give this as a result:

<National_Identities/>

Jobs90312 Mr or Mrs. 500 Points: 533 More actions · Answer 6

Mark Cowne wrote:

Use ISNULL

SELECT ISNULL(
(SELECT 'CNIC' as ID_TYPE_01,
       MAX(CASE WHEN NatID_Type = 'CNIC' THEN NatID_Num END) AS ID_NUMBER_01,
   'PASSPORT' as ID_TYPE_02,
       MAX(CASE WHEN NatID_Type = 'PASSPORT' THEN NatID_Num END) AS ID_NUMBER_02,
   'NTN' as ID_TYPE_03,
       MAX(CASE WHEN NatID_Type = 'NTN' THEN NatID_Num END) AS ID_NUMBER_03
FROM National_Identity
WHERE 
Active = 1
and
NatId_Record_ID_FK = 'xxxFIA-001299'
GROUP BY NatId_Record_ID_FK
FOR XML PATH('National_Identity'), ROOT('National_Identities'),TYPE),'<National_Identities/>');

Thanks for providing this solution.

I have another case related to it.

What if there are two passports and one cnic of an individual and I have to print both passports like this:

123

And if any value is null then it should just print that tag for e.g. <ID_NUMBER_03/>

here is the sample data:

drop table national_identity_test;

create table national_identity_test(
id int identity(1,1),
uniqueid nvarchar(299) null,
name nvarchar (199) null,
natid_type nvarchar(200) null,
natid_num nvarchar(200) null,
active int null,
individual_list_id_fk int null
)

insert into national_identity_test
values
('FIA-000911','john','cnic','4210129195193',1,4),
('FIA-000911','john','passport','TB1805191',1,4),
('FIA-000911','john','passport','540454309',1,4),
('FIA-000912','kevin','passport','555-kevin',1,4)

select * from national_identity_test;

---

SELECT 'CNIC' as ID_TYPE_01,
 MAX(CASE WHEN NatID_Type = 'CNIC' THEN NatID_Num END) AS ID_NUMBER_01,
 'PASSPORT' as ID_TYPE_02,
        MAX(CASE WHEN NatID_Type = 'PASSPORT' THEN NatID_Num END) AS ID_NUMBER_02,
   'NTN' as ID_TYPE_03,
       MAX(CASE WHEN NatID_Type = 'NTN' THEN NatID_Num END) AS ID_NUMBER_03


FROM National_Identity_test NIz
WHERE 
Active = 1
and Individual_List_ID_FK = 4
--AND Alz.Individual_Id  = IND.Individual_Id 
and NIz.uniqueid = 'FIA-000911'

---


SELECT 'CNIC' as ID_TYPE_01,
 MAX(CASE WHEN NatID_Type = 'CNIC' THEN NatID_Num END) AS ID_NUMBER_01,
 'PASSPORT' as ID_TYPE_02,
        MAX(CASE WHEN NatID_Type = 'PASSPORT' THEN NatID_Num END) AS ID_NUMBER_02,
   'NTN' as ID_TYPE_03,
       MAX(CASE WHEN NatID_Type = 'NTN' THEN NatID_Num END) AS ID_NUMBER_03


FROM National_Identity_test NIz
WHERE 
Active = 1
and Individual_List_ID_FK = 4
--AND Alz.Individual_Id  = IND.Individual_Id 
and NIz.uniqueid = 'FIA-000911'
FOR XML PATH ('National_Identity'), --ROOT('National_Identities'),
ELEMENTS XSINIL,
type

Mark Cowne One Orange Chip Points: 26952 More actions · Answer 7

Something like this?

WITH GroupedNational_Identity AS (
SELECT uniqueid, natid_type, STRING_AGG(natid_num,'|') AS natid_num, active, individual_list_id_fk
FROM national_identity_test
GROUP BY uniqueid, natid_type, active, individual_list_id_fk
)
SELECT 'CNIC' as ID_TYPE_01,
 MAX(CASE WHEN NatID_Type = 'CNIC' THEN NatID_Num END) AS ID_NUMBER_01,
 'PASSPORT' as ID_TYPE_02,
        MAX(CASE WHEN NatID_Type = 'PASSPORT' THEN NatID_Num END) AS ID_NUMBER_02,
   'NTN' as ID_TYPE_03,
       MAX(CASE WHEN NatID_Type = 'NTN' THEN NatID_Num END) AS ID_NUMBER_03
FROM GroupedNational_Identity NIz
WHERE 
Active = 1
and Individual_List_ID_FK = 4
--AND Alz.Individual_Id  = IND.Individual_Id 
and NIz.uniqueid = 'FIA-000911'
FOR XML PATH ('National_Identity'), --ROOT('National_Identities'),
ELEMENTS XSINIL,
type

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537

Jobs90312 Mr or Mrs. 500 Points: 533 More actions · Answer 8

Mark Cowne wrote:

Something like this?

WITH GroupedNational_Identity AS (
SELECT uniqueid, natid_type, STRING_AGG(natid_num,'|') AS natid_num, active, individual_list_id_fk
FROM national_identity_test
GROUP BY uniqueid, natid_type, active, individual_list_id_fk
)
SELECT 'CNIC' as ID_TYPE_01,
 MAX(CASE WHEN NatID_Type = 'CNIC' THEN NatID_Num END) AS ID_NUMBER_01,
 'PASSPORT' as ID_TYPE_02,
        MAX(CASE WHEN NatID_Type = 'PASSPORT' THEN NatID_Num END) AS ID_NUMBER_02,
   'NTN' as ID_TYPE_03,
       MAX(CASE WHEN NatID_Type = 'NTN' THEN NatID_Num END) AS ID_NUMBER_03
FROM GroupedNational_Identity NIz
WHERE 
Active = 1
and Individual_List_ID_FK = 4
--AND Alz.Individual_Id  = IND.Individual_Id 
and NIz.uniqueid = 'FIA-000911'
FOR XML PATH ('National_Identity'), --ROOT('National_Identities'),
ELEMENTS XSINIL,
type

This works.

Although I have to combine this with main part of my code which consists of data being fetched from other tables, when executed it forms the combined xml code which then I transfer to xml file.

How do I integrate WITH statement code with other part?

Jobs90312 Mr or Mrs. 500 Points: 533 More actions · Answer 9

Mark Cowne wrote:

Something like this?

WITH GroupedNational_Identity AS (
SELECT uniqueid, natid_type, STRING_AGG(natid_num,'|') AS natid_num, active, individual_list_id_fk
FROM national_identity_test
GROUP BY uniqueid, natid_type, active, individual_list_id_fk
)
SELECT 'CNIC' as ID_TYPE_01,
 MAX(CASE WHEN NatID_Type = 'CNIC' THEN NatID_Num END) AS ID_NUMBER_01,
 'PASSPORT' as ID_TYPE_02,
        MAX(CASE WHEN NatID_Type = 'PASSPORT' THEN NatID_Num END) AS ID_NUMBER_02,
   'NTN' as ID_TYPE_03,
       MAX(CASE WHEN NatID_Type = 'NTN' THEN NatID_Num END) AS ID_NUMBER_03
FROM GroupedNational_Identity NIz
WHERE 
Active = 1
and Individual_List_ID_FK = 4
--AND Alz.Individual_Id  = IND.Individual_Id 
and NIz.uniqueid = 'FIA-000911'
FOR XML PATH ('National_Identity'), --ROOT('National_Identities'),
ELEMENTS XSINIL,
type

Hi again. Is there any alternative of STRING_AGG for sql 2016 because it is giving me error when I am deploying my code to sql 2016 instance.

Your provided code is working fine in sql 2019....

Jo Pattyn SSC-Dedicated Points: 32345 More actions · Answer 10

An alternative for STRING_AGG is SELECT ... FOR XML_PATH

https://www.itprotoday.com/sql-server/ordered-set-functions-whats-new-and-missing-sql-server-vnext

This reply was modified 1 year, 10 months ago by Jo Pattyn.