***************
Table Structure
***************
CREATE TABLE [dbo].[tblEmpData](
	[EmpId] [bigint] NOT NULL,
	[Name] [varchar](100) NULL,
	[Country] [varchar](100) NULL,
	[Dob] [datetime] NULL,
	[DoE] [datetime] NULL,
	[Address1] [varchar](500) NULL,
	[Address2] [varchar](500) NULL,
 CONSTRAINT [PK_tblEmpData] PRIMARY KEY CLUSTERED 
(
	[EmpId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

******************
SAMPLE XML OUTPUT
******************
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<RecSearch TotalResultsOnPage="500" TotalResults="1004521" TotalPages="2009" PageSize="500" CurrentPage="1">
<SearchRes>
	<Employee EmpId ="1">
    		<Name>John Hammond</Name>
    		<Country>United States</Country>
		<Dob>1987-07-21T23:00:00.000Z</Dob>
		<DoE></DoE>
		<Address1>
			<AddressTypeNames/>
			<AddressTypeType>Address1_USA</AddressTypeType>
		</Address1>
		<Address2>
			<AddressTypeNames/>
			<AddressTypeType>Address2_AUS</AddressTypeType>
		</Address1>
  	</Employee>
  	<Employee EmpId = "2">
    		<Name>Mudassar Khan</Name>
    		<Country>India</Country>
		<Dob>1975-06-10T23:00:00.000Z</Dob>
		<DoE></DoE>
		<Address1>
			<AddressTypeNames/>
			<AddressTypeType>Address1_IND</AddressTypeType>
		</Address1>
		<Address2>
			<AddressTypeNames/>
			<AddressTypeType>Address2_SING</AddressTypeType>
		</Address2>
  	</Employee>
  	<Employee EmpId ="3">
    		<Name>Suzanne Mathews</Name>
    		<Country>France</Country>
		<Dob>1990-04-13T23:00:00.000Z</Dob>
		<DoE></DoE>
		<Address1>
			<AddressTypeNames/>
			<AddressTypeType>Address1_MAL</AddressTypeType>
		</Address1>
		<Address2>
			<AddressTypeNames/>
			<AddressTypeType>Address2_CANADA</AddressTypeType>
		</Address2>
  	</Employee>
  	<Employee EmpId ="4">
    		<Name>Robert Schidner</Name>
    		<Country>Russia</Country>
		<Dob>1989-08-18T23:00:00.000Z</Dob>
		<DoE></DoE>
		<Address1>
			<AddressTypeNames/>
			<AddressTypeType>Address1_UK</AddressTypeType>
		</Address1>
		<Address2>
			<AddressTypeNames/>
			<AddressTypeType>Address2_NZ</AddressTypeType>
		</Address2>
  	</Employee>
</SearchRes>
</RecSearch>