please help to create a native sql query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

please help to create a native sql query

Author

Topic

crisgomez
Starting Member

3 Posts

Posted - 2010-07-28 : 10:36:02

I have an application that display the data below. The problem is it is not purely generated by sql query, it was generated by sql and some code in c# to obtain the result below.All I want now is to generate data below using a pure sql.

You can excute the Stored Procedure the script below to see some result

@c is a parameter for company Id.
@folderId is parameter for Unprocessed,Disqualified,Failed, Hired is used only for condition.Every condition has its own query.
@sId is a parameter for Specialization

Here is the flow, the admin of the system will create an account for clients and send them a notification. this clients are the recuiters who are in need of expert people in different specialization. The client will verify the email and then after that, the client user will redirected to Client dashboard. The client will choose the specialization(takenote specialization is a link) he needs, when he click the specialization it will display the expert candidate of the specific specialization(takenote that we take the latest specialization of candidate or applicant, if the latest specialization of the candidate on the employmentdetails table is IT/Computer - Software, then the candidate will belong to IT/Computer - Software specialization list ),and please also take note that the Years of experience is the sum of startdate and enddate of employment history of the particular candidate ,see example below

# Specialization Unprocessed Applications Total Applications
1 Actuarial Science/Statistics 3 3
2 Agriculture/Forestry/Fisheries 3 1
3 IT/Computer - Hardware 1 1
4 IT/Computer - Software 3 3
Total 10 10

--The result below are the expert candidate of the choosen specialization-THIS IS WHAT I NEED

Name Latest Position Years of Experience Expected Salary Top Skills Current Address

Honasan, Gregorio Pimentel Web Developer 2 90,000 .Net,Java Sb, State1
Florendo, Xandrick Programmer 3 35,000 .Net,Php Sb, State3

As of the moment when you excute the store procedure it will display the data

here is a sample of my store procedure

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[Get_Applicant_List] (@cId Bigint,@sId int,@folderId int)
AS
BEGIN

--here Uprocess Start
if (@folderId=1)
begin
select empdetails.id
,empdetails.AId
,u.Firstname
,u.lastname
,u.middlename
,ed2.SpecializationId
from (select max(eds.id) as id
,eds.aid
from employmentdetails eds
where eds.aid not in(select aid
from applicationstatus)
group by eds.aid)empdetails
inner join employmentdetails ed2
on empdetails.id=ed2.id
inner join users u
on empdetails.aid=u.id
where u.RoleId=3
and u.UserStatusId=1
and ed2.SpecializationId=@sId
union all
select empdetails.id
,empdetails.AId
,u.Firstname
,u.lastname
,u.middlename
,ed2.SpecializationId
from (select max(ed.id) as id
,ed.aid
from employmentdetails ed
where ed.aid in(select aid
from applicationstatus
where cId<>@cId and apstatusid<>4)
group by ed.aid)empdetails
inner join employmentdetails ed2
on empdetails.id=ed2.id
inner join users u
on empdetails.aid=u.id
where u.RoleId=3
and u.UserStatusId=1
and ed2.SpecializationId=@sId
and empdetails.aId not in (select aid
from applicationstatus
where cId=@cId and apstatusid<>4)

end
--here Uprocess End
--Disqualified,Failed
else if (@folderId=2)
begin
select empdetails.id
,empdetails.aid
,u.Firstname
,u.lastname
,u.middlename
,ed2.SpecializationId
from (select max(ed.id) as id
,ed.aid
from employmentdetails ed
where ed.aid in(select aid
from applicationstatus
where cId=@cId and apstatusid=2)
group by ed.aid)empdetails
inner join employmentdetails ed2
on empdetails.id=ed2.id
inner join users u
on empdetails.aid=u.id
where u.RoleId=3
and u.UserStatusId=1
and ed2.SpecializationId=@sId
end
--Disqualified,Failed

--Hired
else
begin
select empdetails.id
,empdetails.AId
,u.Firstname
,u.lastname
,u.middlename
,ed2.SpecializationId
from (select max(ed.id) as id
,ed.aid
from employmentdetails ed
where ed.aid in(select aid
from applicationstatus
where cId=@cId and apstatusid<>2)
group by ed.aid)empdetails
inner join employmentdetails ed2
on empdetails.id=ed2.id
inner join users u
on empdetails.aid=u.id
where u.RoleId=3
and u.UserStatusId=1
and ed2.SpecializationId=@sId
end
--Hired
select count(id) as totalUnprocess from(select empdetails.id
,empdetails.AId
,u.Firstname
,u.lastname
,ed2.SpecializationId
from (select max(eds.id) as id
,eds.aid
from employmentdetails eds
where eds.aid not in(select aid
from applicationstatus)
group by eds.aid)empdetails
inner join employmentdetails ed2
on empdetails.id=ed2.id
inner join users u
on empdetails.aid=u.id
where u.RoleId=3
and u.UserStatusId=1
and ed2.SpecializationId=@sId
union all
select empdetails.id
,empdetails.AId
,u.Firstname
,u.lastname
,ed2.SpecializationId
from (select max(ed.id) as id
,ed.aid
from employmentdetails ed
where ed.aid in(select aid
from applicationstatus
where cId<>@cId and apstatusid<>4)
group by ed.aid)empdetails
inner join employmentdetails ed2
on empdetails.id=ed2.id
inner join users u
on empdetails.aid=u.id
where u.RoleId=3
and u.UserStatusId=1
and ed2.SpecializationId=@sId
and empdetails.aId not in (select aid
from applicationstatus
where cId=@cId and apstatusid<>4))unprocessapplicants

select count(id) as totalshorlisted from(select empdetails.id
,empdetails.aid
,u.Firstname
,u.lastname
,ed2.SpecializationId
from (select max(ed.id) as id
,ed.aid
from employmentdetails ed
where ed.aid in(select aid
from applicationstatus
where cId=@cId and apstatusid=2)
group by ed.aid)empdetails
inner join employmentdetails ed2
on empdetails.id=ed2.id
inner join users u
on empdetails.aid=u.id
where u.RoleId=3
and u.UserStatusId=1
and ed2.SpecializationId=@sId
)shorlisted

select count(id) as totalarchives from(select empdetails.id
,empdetails.AId
,u.Firstname
,u.lastname
,ed2.SpecializationId
from (select max(ed.id) as id
,ed.aid
from employmentdetails ed
where ed.aid in(select aid
from applicationstatus
where cId=@cId and apstatusid<>2)
group by ed.aid)empdetails
inner join employmentdetails ed2
on empdetails.id=ed2.id
inner join users u
on empdetails.aid=u.id
where u.RoleId=3
and u.UserStatusId=1
and ed2.SpecializationId=@sId)archived
END

//Function that generate data private void GenerateData(int sId,int foldertype) { long AId = 0; int intCount = 0; string strName = string.Empty; System.Data.DataSet dset = new DataSet();

long LNG_UID = ((CustomIdentity)Context.User.Identity).UserPK;

UsersModelView objusers = new UsersModelView();
ApplicantDetailsModelView appdetails = new ApplicantDetailsModelView();
ApplicationStatusModelView objstatus = new ApplicationStatusModelView();
EmploymentDetailsModelView objempDetails = new EmploymentDetailsModelView();
List<ApplicationStatus> lstApplicationStatus = new List<ApplicationStatus>();
List<EmploymentDetails> lstEmploymentDetails = new List<EmploymentDetails>();
List<Users> lstuser = new List<Users>();

dset = appdetails.GetApplicantList(LNG_UID, sId, foldertype);
lstApplicationStatus = objstatus.GetAll();
lstEmploymentDetails = objempDetails.GetAll();

Dictionary<long, int> dicSpcealization = new Dictionary<long, int>();

int intTotalUnprocessed = Convert.ToInt32(dset.Tables[1].Rows[0]["totalUnprocess"]);
int intTotalShortListed = Convert.ToInt32(dset.Tables[2].Rows[0]["totalshorlisted"]);
int intTotalArchives = Convert.ToInt32(dset.Tables[3].Rows[0]["totalarchives"]);

enabledControls(true, foldertype, intTotalUnprocessed, intTotalShortListed, intTotalArchives);

foreach (System.Data.DataRow usr in dset.Tables[0].Rows)
{
intCount = 0;
string strExpertise = string.Empty;
AId = Convert.ToInt64(usr["AId"]);

var objEmploymentDetails = (from emp in lstEmploymentDetails
where (emp.AId == AId)
orderby emp.Id descending
select new { emp.Position, emp.Startdate, emp.Enddate, emp.SpecializationId });

var firstelement = objEmploymentDetails.ElementAt(0);

if (!dicSpcealization.ContainsKey(firstelement.SpecializationId))
{

ExpertiseModelView expertise = new ExpertiseModelView();

List<Expertise> objExpertise = (from exp in expertise.GetAll()
where (exp.AId == AId)
select new Expertise { Id = exp.Id, Expertise1 = exp.Expertise1 }

).ToList<Expertise>();

foreach (Expertise exp in objExpertise)
{
intCount += 1;
if (intCount == 3) break;
strExpertise += string.Format("{0},", exp.Expertise1);
}

ApplicantDetailsModelView applicants = new ApplicantDetailsModelView();
List<ApplicantDetails> applicantsdata = applicants.GetApplicantDetailsById(Convert.ToInt64(AId));

CountryModelView mvcountry = new CountryModelView();
List<Country> objCountry = mvcountry.GetAll();

var objapplicantsdata = (from appdata in applicants.GetApplicantDetailsById(Convert.ToInt64(AId))
join
ctr in objCountry
on Convert.ToInt64(appdata.CountryId) equals ctr.Id
where (appdata.AId == AId)
select new { appdata.StateorRegion, ctr.Code }

).SingleOrDefault();

strName = String.Format("{0}, {1} {2}", usr["Lastname"], usr["Firstname"], usr["Middlename"]);

double yearsofexperience = 0;
foreach (var obj in objEmploymentDetails)
{
yearsofexperience += Appsource.EMS.Dotnet.BusinessLayer.Durable.Utilities.DateDiff(Appsource.EMS.Dotnet.BusinessLayer.Durable.Utilities.DateInterval.Month, Convert.ToDateTime(obj.Startdate), (obj.Enddate != null) ? (obj.Enddate.Length>0) ? Convert.ToDateTime(obj.Enddate) : DateTime.Now : DateTime.Now) / 12;
}

string strSalary = (applicantsdata.Count > 0) ? (applicantsdata[0].ExpectedSalary != null) ? applicantsdata[0].ExpectedSalary : "not provided" : "not provided";
string strExpertse = (strExpertise.Length > 0) ? strExpertise.Substring(0, strExpertise.Length - 1) : "not provided";
string strStateorRegion = (objapplicantsdata != null) ? string.Format("{0}, {1}", (objapplicantsdata.Code != null) ? objapplicantsdata.Code : "not provided", (objapplicantsdata.StateorRegion != null) ? objapplicantsdata.StateorRegion : "not provided") : "not provided";

datalist.Rows.Add(AId, strName, firstelement.Position, yearsofexperience, strSalary, strExpertse, strStateorRegion, AId);
}

}
}

Database Script

create table Expertise(
Id bigint not null identity constraint PK_Expertise primary key,
aId bigint not null,
Expertise varchar(25) not null,
NoInMonthsExperience int,
IsPrimary bit,
sId bigint constraint DF_Expertise_sId default (0)
)
go

create table ApplicantDetails(
Id bigint not null identity constraint PK_ApplicantDetails primary key,
aId bigint not null,
FormerFirstname varchar(25),
FormerLastname varchar(25),
FormerMiddlename varchar(25),
Age int,
Birthdate datetime,
Gender int,
MaritalStatus int,
MobileNo varchar(15),
TelephoneNo varchar(15),
FaxNo varchar(15),
GovernmentIdIssue varchar(25),
Nationality int,
Address1 varchar(50),
Address2 varchar(50),
City varchar(25),
Province varchar(25),
StateorRegion varchar(25),
CountryId int,
PostalCode nchar(10),
StartWorkType int,
NoofMonths int,
AvailableDate datetime,
ExpectedSalary varchar(50),
ResumeStatus int constraint DF_ApplicantDetails_ResumeStatus default (0),
DateCreated datetime,
DateSavedPublished datetime
)
go

create table Country(
Id bigint not null identity constraint PK_Country primary key,
Code varchar(10) not null,
Description varchar(55) not null,
Status int not null,
DateCreated datetime not null,
DateUpdated datetime not null,
CreatedBy bigint,
UpdatedBy bigint
)
go

create table EmploymentDetails(

Id bigint not null identity constraint PK_EmploymentDetails primary key, aId bigint not null, Startdate datetime, Enddate datetime, Position varchar(30), PositionLevelId bigint not null, SpecializationId bigint not null, PositionId bigint not null, StartSalary varchar(50), EndSalary varchar(50), DescriptionofDuties nvarchar(1000), ReasonforLeaving nvarchar(200), CompanyName nvarchar(100), TypeofBusiness varchar(50), Address1 varchar(25), Address2 varchar(25), City varchar(25), Province varchar(25), StateorRegion varchar(25), CountryId bigint, PostalCode varchar(10) ) go

create table Users(
Id bigint not null identity constraint PK_AdminUsers primary key,
ParentId bigint not null,
Firstname varchar(30) not null,
Lastname varchar(25) not null,
Middlename varchar(25),
EncryptPassword nvarchar(200) not null,
Username nvarchar(25) not null,
Email nvarchar(50) not null,
AlternativeEmail nvarchar(50),
RoleId bigint not null,
UserStatusId int not null
)
go

create table ApplicationStatus(
Id bigint not null identity constraint PK_ApplicationStatus primary key,
aId bigint not null,
cId bigint not null,
APStatusId int not null,
DateCreated datetime not null,
DateUpdated datetime not null,
Createdby bigint,
UpdatedBy bigint,
sId bigint
)
go

INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (62, 43, N'sds', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (63, 43, N'gg', 5, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (78, 151, N'ghghg', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (79, 151, N'ghh', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (80, 151, N'rgtg', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (81, 151, N'rtrt', 4, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (82, 151, N'ghgh', 5, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (83, 151, N'tyuyu', 6, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (84, 151, N'fgfg', 4, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (85, 151, N'yuu', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (86, 151, N'dfdf', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (87, 151, N'gtyy', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (88, 151, N'dfdf', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (89, 151, N'df', 3, 1, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (90, 151, N'ssd', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (91, 151, N'dfd', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (92, 151, N'dfdf', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (93, 151, N'fd', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (94, 151, N'dfdf', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (95, 151, N'dd', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (97, 151, N'sdsds', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (98, 151, N'hghg', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (99, 151, N'hgh', 5, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (100, 151, N'sdds', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (101, 151, N'dff', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (102, 151, N'rtrr', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (103, 151, N'fgfg', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (104, 151, N'bnbnb', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (105, 151, N'sdss', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (108, 153, N'hgh', 5, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (109, 153, N'ghg', 5, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (110, 153, N'554', 4, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (111, 153, N'ghg', 5, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (112, 153, N'fttr', 4, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (113, 154, N'.NEt', 5, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (114, 154, N'Java', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (115, 154, N'PHP', 3, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (151, 168, N'ghgh', 4, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (152, 168, N'sdssd', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (183, 156, N'909', 7, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (185, 156, N'tyty', 6, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (193, 185, N'asas', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (194, 184, N'.Net', 4, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (195, 184, N'Php', 4, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (196, 168, N'sdsd', 23, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (197, 168, N'wew12', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (198, 168, N'qwqw', 2, 0, 1)
INSERT [dbo].[Expertise] ([Id], [aId], [Expertise], [NoInMonthsExperience], [IsPrimary], [sId]) VALUES (199, 168, N'erer', 24, 0, 1)

INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (125, 168, NULL, NULL, NULL, 30, CAST(0x0000728D00000000 AS DateTime), 2, 2, N'+639178841980', N'(53)321-4585', N'(53)321-4585', N'not provided', 182, N'124 san jose st.,', N'nicanor village', N'Mandaluyong', NULL, N'NCRQ', 194, NULL, 2, 1, CAST(0x00009DE800000000 AS DateTime), N'7,100', 1, CAST(0x00009D98011AF06C AS DateTime), CAST(0x00009D98011AF198 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (126, 154, NULL, NULL, NULL, 22, CAST(0x00007D6400000000 AS DateTime), 1, 1, N'+639178841980', NULL, NULL, N'not provided', 177, N'141 valero st.,', NULL, N'makati', NULL, N'State1', 194, NULL, NULL, NULL, NULL, N'90,000', 1, CAST(0x00009D98011AF06C AS DateTime), CAST(0x00009D98011AF198 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (127, 156, NULL, NULL, NULL, 20, CAST(0x00007FB900000000 AS DateTime), 1, 2, N'+639178841980', N'(233)223-2323', N'(243)223-2323', N'not provided', 194, N'36 Green St. ', N'fgfg', N'makati', NULL, N'rererefgf', 194, NULL, 2, NULL, CAST(0x00009D7E00000000 AS DateTime), N'80,000', 1, CAST(0x00009D98011AF12C AS DateTime), CAST(0x00009D98011AF1DC AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (129, 183, NULL, NULL, NULL, 30, CAST(0x0000727700000000 AS DateTime), NULL, NULL, N'+639178841980', NULL, NULL, NULL, 194, N'124 san jose st.,', NULL, N'Mandaluyong', NULL, N'State2', 194, NULL, NULL, NULL, NULL, N'10,000', 1, CAST(0x00009D98011AF06C AS DateTime), CAST(0x00009D98011AF198 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (130, 184, NULL, NULL, NULL, 29, CAST(0x000072F700000000 AS DateTime), NULL, NULL, N'+639178841980', NULL, NULL, NULL, 194, NULL, NULL, N'makati', NULL, N'State3', 194, NULL, NULL, NULL, NULL, N'35,000', 1, CAST(0x00009D98011AF06C AS DateTime), CAST(0x00009D98011AF198 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (131, 185, NULL, NULL, NULL, 15, CAST(0x000087EC00000000 AS DateTime), NULL, NULL, N'+639397856120', NULL, NULL, NULL, 194, N'124 san jose st.,', NULL, N'Mandaluyong', NULL, N'State4', 194, NULL, NULL, NULL, NULL, N'13,900', 2, CAST(0x00009DA000A65A64 AS DateTime), CAST(0x00009DA000A65A64 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (132, 186, NULL, NULL, NULL, 30, CAST(0x0000726800000000 AS DateTime), NULL, NULL, N'+639178841980', NULL, NULL, NULL, 194, NULL, NULL, N'makati', NULL, N'State5', 194, NULL, NULL, NULL, NULL, N'13,900', 2, CAST(0x00009DA300A2B63A AS DateTime), CAST(0x00009DA300A2B63A AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (133, 187, NULL, NULL, NULL, 30, CAST(0x0000726500000000 AS DateTime), NULL, NULL, N'+639178841980', NULL, NULL, NULL, 194, NULL, NULL, N'makati', NULL, N'State6', 194, NULL, NULL, NULL, NULL, N'10,000', 2, CAST(0x00009DA301035C15 AS DateTime), CAST(0x00009DA301035C15 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (134, 188, NULL, NULL, NULL, 24, CAST(0x00007A8A00000000 AS DateTime), 1, 1, N'09165015311', N'(02)640-5312', N'()640-5312', N'not provided', 177, N'36 Green St. ', N'Munting Bahayan Pinagbuha', N'Pasig City', NULL, N'Manila', 177, NULL, 1, 1, NULL, N'30,300', 1, CAST(0x00009DA4014D577A AS DateTime), CAST(0x00009DA6002858F1 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (135, 189, NULL, NULL, NULL, 25, CAST(0x0000794900000000 AS DateTime), NULL, NULL, N'+639285207452', NULL, NULL, NULL, 194, NULL, NULL, N'makati', NULL, N'State7', 194, NULL, NULL, NULL, NULL, N'13,900', 2, CAST(0x00009DA401721B10 AS DateTime), CAST(0x00009DA401721B10 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (136, 190, NULL, NULL, NULL, 24, CAST(0x00007ABA00000000 AS DateTime), NULL, NULL, N'+639162283554', NULL, NULL, NULL, 194, N'124 san jose st.,', NULL, N'Mandaluyong', NULL, N'State8', 194, NULL, NULL, NULL, NULL, N'13,900', 2, CAST(0x00009DA50147BB09 AS DateTime), CAST(0x00009DA50147BB09 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (137, 191, NULL, NULL, NULL, 24, CAST(0x00007A8A00000000 AS DateTime), NULL, NULL, N'+6309165015311', NULL, NULL, NULL, 194, N'36 Green St. ', NULL, N'makati', NULL, N'State5', 194, NULL, NULL, NULL, NULL, N'30,300', 1, CAST(0x00009DA90171F529 AS DateTime), CAST(0x00009DA901723285 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (138, 192, NULL, NULL, NULL, 15, CAST(0x000087CA00000000 AS DateTime), NULL, NULL, N'+639168821290', NULL, NULL, NULL, 194, NULL, NULL, N'makati', NULL, N'State5', 194, NULL, NULL, NULL, NULL, N'10,000', 1, CAST(0x00009DA90176603E AS DateTime), CAST(0x00009DA90176807C AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (139, 193, NULL, NULL, NULL, 30, CAST(0x0000725C00000000 AS DateTime), NULL, NULL, N'+639178851979', NULL, NULL, NULL, 194, N'124 san jose st.,', NULL, N'Mandaluyong', NULL, N'State5', 194, NULL, 2, NULL, CAST(0x00009DAE00000000 AS DateTime), N'35,000', 2, CAST(0x00009DAD0101E1B8 AS DateTime), CAST(0x00009DAD0101E1B8 AS DateTime))
INSERT [dbo].[ApplicantDetails] ([Id], [aId], [FormerFirstname], [FormerLastname], [FormerMiddlename], [Age], [Birthdate], [Gender], [MaritalStatus], [MobileNo], [TelephoneNo], [FaxNo], [GovernmentIdIssue], [Nationality], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode], [StartWorkType], [NoofMonths], [AvailableDate], [ExpectedSalary], [ResumeStatus], [DateCreated], [DateSavedPublished]) VALUES (140, 194, NULL, NULL, NULL, 15, CAST(0x000087C900000000 AS DateTime), NULL, NULL, N'+637837283782', NULL, NULL, NULL, 194, NULL, NULL, N'makati', NULL, N'State5', 194, NULL, NULL, NULL, NULL, NULL, 2, CAST(0x00009DB900A2273B AS DateTime), CAST(0x00009DB900A22779 AS DateTime))

INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (3, N'ad', N'Andorra', 1, CAST(0x00009D150122237B AS DateTime), CAST(0x00009D150122237B AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (4, N'ae', N'United Arab Emirates', 1, CAST(0x00009D150122A0BB AS DateTime), CAST(0x00009D150122A0BB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (5, N'af', N'Afghanistan', 1, CAST(0x00009D1501234C91 AS DateTime), CAST(0x00009D1501234C91 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (6, N'ag', N'Antigua and Barbuda', 1, CAST(0x00009D1501234C91 AS DateTime), CAST(0x00009D1501234C91 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (7, N'ai', N'Anguilla', 1, CAST(0x00009D1501234C91 AS DateTime), CAST(0x00009D1501234C91 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (8, N'al', N'Albania', 1, CAST(0x00009D1501234C91 AS DateTime), CAST(0x00009D1501234C91 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (9, N'am', N'Armenia', 1, CAST(0x00009D1501234C91 AS DateTime), CAST(0x00009D1501234C91 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (10, N'an', N'Netherlands Antilles', 1, CAST(0x00009D1501234C92 AS DateTime), CAST(0x00009D1501234C92 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (11, N'ao', N'Angola', 1, CAST(0x00009D1501234C92 AS DateTime), CAST(0x00009D1501234C92 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (12, N'aq', N'Antarctica', 1, CAST(0x00009D1501234C92 AS DateTime), CAST(0x00009D1501234C92 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (13, N'ar', N'Argentina', 1, CAST(0x00009D1501234C92 AS DateTime), CAST(0x00009D1501234C92 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (14, N'as', N'Samoa (US)', 1, CAST(0x00009D1501234C92 AS DateTime), CAST(0x00009D1501234C92 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (15, N'at', N'Austria', 1, CAST(0x00009D1501234C92 AS DateTime), CAST(0x00009D1501234C92 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (16, N'au', N'Australia', 1, CAST(0x00009D1501234C92 AS DateTime), CAST(0x00009D1501234C92 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (17, N'aw', N'Aruba', 1, CAST(0x00009D1501234C92 AS DateTime), CAST(0x00009D1501234C92 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (18, N'az', N'Azerbaijan', 1, CAST(0x00009D1501234C92 AS DateTime), CAST(0x00009D1501234C92 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (19, N'ba', N'Bosnia and Herzegovina', 1, CAST(0x00009D1501234C93 AS DateTime), CAST(0x00009D1501234C93 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (20, N'bb', N'Barbados', 1, CAST(0x00009D1501234C93 AS DateTime), CAST(0x00009D1501234C93 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (21, N'bd', N'Bangladesh', 1, CAST(0x00009D1501234C93 AS DateTime), CAST(0x00009D1501234C93 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (22, N'be', N'Belgium', 1, CAST(0x00009D1501234C93 AS DateTime), CAST(0x00009D1501234C93 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (23, N'bf', N'Burkina Faso', 1, CAST(0x00009D1501234C93 AS DateTime), CAST(0x00009D1501234C93 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (24, N'bg', N'Bulgaria', 1, CAST(0x00009D1501234C93 AS DateTime), CAST(0x00009D1501234C93 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (25, N'bh', N'Bahrain', 1, CAST(0x00009D1501234C93 AS DateTime), CAST(0x00009D1501234C93 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (26, N'bi', N'Burundi', 1, CAST(0x00009D1501234C93 AS DateTime), CAST(0x00009D1501234C93 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (27, N'bj', N'Benin', 1, CAST(0x00009D1501234C94 AS DateTime), CAST(0x00009D1501234C94 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (28, N'bm', N'Bermuda', 1, CAST(0x00009D1501234C9C AS DateTime), CAST(0x00009D1501234C9C AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (29, N'bn', N'Brunei Darussalam', 1, CAST(0x00009D1501234C9C AS DateTime), CAST(0x00009D1501234C9C AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (30, N'bo', N'Bolivia', 1, CAST(0x00009D1501234C9D AS DateTime), CAST(0x00009D1501234C9D AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (31, N'br', N'Brazil', 1, CAST(0x00009D1501234C9D AS DateTime), CAST(0x00009D1501234C9D AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (32, N'bs', N'Bahamas', 1, CAST(0x00009D1501234C9D AS DateTime), CAST(0x00009D1501234C9D AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (33, N'bt', N'Bhutan', 1, CAST(0x00009D1501234C9D AS DateTime), CAST(0x00009D1501234C9D AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (34, N'bv', N'Bouvet Island', 1, CAST(0x00009D1501234C9D AS DateTime), CAST(0x00009D1501234C9D AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (35, N'bw', N'Botswana', 1, CAST(0x00009D1501234C9D AS DateTime), CAST(0x00009D1501234C9D AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (36, N'by', N'Belarus', 1, CAST(0x00009D1501234C9E AS DateTime), CAST(0x00009D1501234C9E AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (37, N'bz', N'Belize', 1, CAST(0x00009D1501234C9E AS DateTime), CAST(0x00009D1501234C9E AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (38, N'ca', N'Canada', 1, CAST(0x00009D1501234C9E AS DateTime), CAST(0x00009D1501234C9E AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (39, N'cc', N'Cocos Island', 1, CAST(0x00009D1501234C9E AS DateTime), CAST(0x00009D1501234C9E AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (40, N'cd', N'Democratic Republic of the Congo', 1, CAST(0x00009D1501234C9E AS DateTime), CAST(0x00009D1501234C9E AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (41, N'cf', N'Central African Republic', 1, CAST(0x00009D1501234C9E AS DateTime), CAST(0x00009D1501234C9E AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (42, N'cg', N'Congo', 1, CAST(0x00009D1501234C9E AS DateTime), CAST(0x00009D1501234C9E AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (43, N'ch', N'Switzerland', 1, CAST(0x00009D1501234C9F AS DateTime), CAST(0x00009D1501234C9F AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (44, N'ci', N'Côte d''Ivoire', 1, CAST(0x00009D1501234C9F AS DateTime), CAST(0x00009D1501234C9F AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (45, N'ck', N'Cook Islands', 1, CAST(0x00009D1501234C9F AS DateTime), CAST(0x00009D1501234C9F AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (46, N'cl', N'Chile', 1, CAST(0x00009D1501234C9F AS DateTime), CAST(0x00009D1501234C9F AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (47, N'cm', N'Cameroon', 1, CAST(0x00009D1501234C9F AS DateTime), CAST(0x00009D1501234C9F AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (48, N'cn', N'China', 1, CAST(0x00009D1501234C9F AS DateTime), CAST(0x00009D1501234C9F AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (49, N'co', N'Colombia', 1, CAST(0x00009D1501234C9F AS DateTime), CAST(0x00009D1501234C9F AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (50, N'cr', N'Costa Rica', 1, CAST(0x00009D1501234C9F AS DateTime), CAST(0x00009D1501234C9F AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (51, N'cs', N'Serbia', 1, CAST(0x00009D1501234CA0 AS DateTime), CAST(0x00009D1501234CA0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (52, N'cu', N'Cuba', 1, CAST(0x00009D1501234CA0 AS DateTime), CAST(0x00009D1501234CA0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (53, N'cv', N'Cape Verde', 1, CAST(0x00009D1501234CA0 AS DateTime), CAST(0x00009D1501234CA0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (54, N'cx', N'Christmas Island', 1, CAST(0x00009D1501234CA0 AS DateTime), CAST(0x00009D1501234CA0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (55, N'cy', N'Cyprus', 1, CAST(0x00009D1501234CA0 AS DateTime), CAST(0x00009D1501234CA0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (56, N'cz', N'Czech Republic', 1, CAST(0x00009D1501234CA0 AS DateTime), CAST(0x00009D1501234CA0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (57, N'de', N'Germany', 1, CAST(0x00009D1501234CA0 AS DateTime), CAST(0x00009D1501234CA0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (58, N'dj', N'Djibouti', 1, CAST(0x00009D1501234CA1 AS DateTime), CAST(0x00009D1501234CA1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (59, N'dk', N'Denmark', 1, CAST(0x00009D1501234CA1 AS DateTime), CAST(0x00009D1501234CA1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (60, N'dm', N'Dominica', 1, CAST(0x00009D1501234CA4 AS DateTime), CAST(0x00009D1501234CA4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (61, N'do', N'Dominican Republic', 1, CAST(0x00009D1501234CA4 AS DateTime), CAST(0x00009D1501234CA4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (62, N'dz', N'Algeria', 1, CAST(0x00009D1501234CA4 AS DateTime), CAST(0x00009D1501234CA4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (63, N'ec', N'Ecuador', 1, CAST(0x00009D1501234CA4 AS DateTime), CAST(0x00009D1501234CA4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (64, N'ee', N'Estonia', 1, CAST(0x00009D1501234CA4 AS DateTime), CAST(0x00009D1501234CA4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (65, N'eg', N'Egypt', 1, CAST(0x00009D1501234CA4 AS DateTime), CAST(0x00009D1501234CA4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (66, N'eh', N'Western sahara', 1, CAST(0x00009D1501234CA5 AS DateTime), CAST(0x00009D1501234CA5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (67, N'er', N'Eritrea', 1, CAST(0x00009D1501234CA5 AS DateTime), CAST(0x00009D1501234CA5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (68, N'es', N'Spain', 1, CAST(0x00009D1501234CA5 AS DateTime), CAST(0x00009D1501234CA5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (69, N'et', N'Ethiopia', 1, CAST(0x00009D1501234CA5 AS DateTime), CAST(0x00009D1501234CA5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (70, N'eur', N'European Community', 1, CAST(0x00009D1501234CA5 AS DateTime), CAST(0x00009D1501234CA5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (71, N'fi', N'Finland', 1, CAST(0x00009D1501234CA5 AS DateTime), CAST(0x00009D1501234CA5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (72, N'fj', N'Fiji', 1, CAST(0x00009D1501234CA5 AS DateTime), CAST(0x00009D1501234CA5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (73, N'fk', N'Falkland Islands', 1, CAST(0x00009D1501234CA6 AS DateTime), CAST(0x00009D1501234CA6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (74, N'fm', N'Micronesia (Federated States of)', 1, CAST(0x00009D1501234CA6 AS DateTime), CAST(0x00009D1501234CA6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (75, N'fo', N'Faroe Islands', 1, CAST(0x00009D1501234CA6 AS DateTime), CAST(0x00009D1501234CA6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (76, N'fr', N'France', 1, CAST(0x00009D1501234CA6 AS DateTime), CAST(0x00009D1501234CA6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (77, N'fx', N'France (European Territory)', 1, CAST(0x00009D1501234CA6 AS DateTime), CAST(0x00009D1501234CA6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (78, N'ga', N'Gabon', 1, CAST(0x00009D1501234CA6 AS DateTime), CAST(0x00009D1501234CA6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (80, N'gd', N'Grenada', 1, CAST(0x00009D1501234CAD AS DateTime), CAST(0x00009D1501234CAD AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (81, N'ge', N'Georgia', 1, CAST(0x00009D1501234CAE AS DateTime), CAST(0x00009D1501234CAE AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (82, N'gf', N'French Guyana', 1, CAST(0x00009D1501234CAE AS DateTime), CAST(0x00009D1501234CAE AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (83, N'gh', N'Ghana', 1, CAST(0x00009D1501234CAE AS DateTime), CAST(0x00009D1501234CAE AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (84, N'gi', N'Gibraltar', 1, CAST(0x00009D1501234CAE AS DateTime), CAST(0x00009D1501234CAE AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (85, N'gj', N'gj', 1, CAST(0x00009D1501234CAE AS DateTime), CAST(0x00009D1501234CAE AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (86, N'gl', N'Greenland', 1, CAST(0x00009D1501234CAF AS DateTime), CAST(0x00009D1501234CAF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (87, N'gm', N'Gambia', 1, CAST(0x00009D1501234CAF AS DateTime), CAST(0x00009D1501234CAF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (88, N'gn', N'Guinea', 1, CAST(0x00009D1501234CAF AS DateTime), CAST(0x00009D1501234CAF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (89, N'gp', N'Guadeloupe', 1, CAST(0x00009D1501234CAF AS DateTime), CAST(0x00009D1501234CAF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (90, N'gq', N'Equatorial Guinea', 1, CAST(0x00009D1501234CAF AS DateTime), CAST(0x00009D1501234CAF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (91, N'gr', N'Greece', 1, CAST(0x00009D1501234CAF AS DateTime), CAST(0x00009D1501234CAF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (92, N'gs', N'South Georgia & the South Sandwich', 1, CAST(0x00009D1501234CB0 AS DateTime), CAST(0x00009D1501234CB0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (93, N'gt', N'Guatemala', 1, CAST(0x00009D1501234CB0 AS DateTime), CAST(0x00009D1501234CB0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (94, N'gu', N'Guam (USA)', 1, CAST(0x00009D1501234CB0 AS DateTime), CAST(0x00009D1501234CB0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (95, N'gw', N'Guinea-Bissau', 1, CAST(0x00009D1501234CB0 AS DateTime), CAST(0x00009D1501234CB0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (96, N'gy', N'Guyana', 1, CAST(0x00009D1501234CB0 AS DateTime), CAST(0x00009D1501234CB0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (97, N'hk', N'Hong Kong', 1, CAST(0x00009D1501234CB0 AS DateTime), CAST(0x00009D1501234CB0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (98, N'hm', N'Heard and McDonald Islands', 1, CAST(0x00009D1501234CB1 AS DateTime), CAST(0x00009D1501234CB1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (99, N'hn', N'Honduras', 1, CAST(0x00009D1501234CB1 AS DateTime), CAST(0x00009D1501234CB1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (100, N'hr', N'Croatia', 1, CAST(0x00009D1501234CB1 AS DateTime), CAST(0x00009D1501234CB1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (101, N'ht', N'Haiti', 1, CAST(0x00009D1501234CB1 AS DateTime), CAST(0x00009D1501234CB1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (102, N'hu', N'Hungary', 1, CAST(0x00009D1501234CB2 AS DateTime), CAST(0x00009D1501234CB2 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (103, N'id', N'Indonesia', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
GO
print 'Processed 100 total records'
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (104, N'ie', N'Ireland', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (105, N'il', N'Israel', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (106, N'in', N'India', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (107, N'io', N'British Indian Ocean', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (108, N'iq', N'Iraq', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (109, N'ir', N'Iran (Islamic Republic of)', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (110, N'is', N'Iceland', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (111, N'it', N'Italy', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (112, N'jm', N'Jamaica', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (113, N'jo', N'Jordan', 1, CAST(0x00009D1501234CB3 AS DateTime), CAST(0x00009D1501234CB3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (114, N'jp', N'Japan', 1, CAST(0x00009D1501234CB4 AS DateTime), CAST(0x00009D1501234CB4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (115, N'ke', N'Kenya', 1, CAST(0x00009D1501234CB4 AS DateTime), CAST(0x00009D1501234CB4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (116, N'kg', N'Kyrgyzstan', 1, CAST(0x00009D1501234CB4 AS DateTime), CAST(0x00009D1501234CB4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (117, N'kh', N'Cambodia', 1, CAST(0x00009D1501234CB4 AS DateTime), CAST(0x00009D1501234CB4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (118, N'ki', N'Kiribati', 1, CAST(0x00009D1501234CB4 AS DateTime), CAST(0x00009D1501234CB4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (119, N'km', N'Comoros', 1, CAST(0x00009D1501234CBB AS DateTime), CAST(0x00009D1501234CBB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (120, N'kn', N'Saint Kitts and Nevis', 1, CAST(0x00009D1501234CBB AS DateTime), CAST(0x00009D1501234CBB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (121, N'kp', N'Democratic People''s Republic of Korea', 1, CAST(0x00009D1501234CBC AS DateTime), CAST(0x00009D1501234CBC AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (122, N'kr', N'Republic of Korea', 1, CAST(0x00009D1501234CC2 AS DateTime), CAST(0x00009D1501234CC2 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (123, N'kw', N'Kuwait', 1, CAST(0x00009D1501234CC2 AS DateTime), CAST(0x00009D1501234CC2 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (124, N'ky', N'Cayman Islands', 1, CAST(0x00009D1501234CC3 AS DateTime), CAST(0x00009D1501234CC3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (125, N'kz', N'Kazakhstan', 1, CAST(0x00009D1501234CC3 AS DateTime), CAST(0x00009D1501234CC3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (126, N'la', N'Lao People''s Democratic Republic', 1, CAST(0x00009D1501234CC3 AS DateTime), CAST(0x00009D1501234CC3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (127, N'lb', N'Lebanon', 1, CAST(0x00009D1501234CC3 AS DateTime), CAST(0x00009D1501234CC3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (128, N'lc', N'Saint Lucia', 1, CAST(0x00009D1501234CC3 AS DateTime), CAST(0x00009D1501234CC3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (129, N'li', N'Liechtenstein', 1, CAST(0x00009D1501234CC3 AS DateTime), CAST(0x00009D1501234CC3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (130, N'lk', N'Sri Lanka', 1, CAST(0x00009D1501234CC3 AS DateTime), CAST(0x00009D1501234CC3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (131, N'lr', N'Liberia', 1, CAST(0x00009D1501234CC3 AS DateTime), CAST(0x00009D1501234CC3 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (132, N'ls', N'Lesotho', 1, CAST(0x00009D1501234CC4 AS DateTime), CAST(0x00009D1501234CC4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (133, N'lt', N'Lithuania', 1, CAST(0x00009D1501234CC4 AS DateTime), CAST(0x00009D1501234CC4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (134, N'lu', N'Luxembourg', 1, CAST(0x00009D1501234CC4 AS DateTime), CAST(0x00009D1501234CC4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (135, N'lv', N'Latvia', 1, CAST(0x00009D1501234CC4 AS DateTime), CAST(0x00009D1501234CC4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (136, N'ly', N'Libyan Arab Jamahiriya', 1, CAST(0x00009D1501234CC4 AS DateTime), CAST(0x00009D1501234CC4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (137, N'ma', N'Morocco', 1, CAST(0x00009D1501234CC5 AS DateTime), CAST(0x00009D1501234CC5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (138, N'mc', N'Monaco', 1, CAST(0x00009D1501234CC5 AS DateTime), CAST(0x00009D1501234CC5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (139, N'md', N'Republic of Moldova', 1, CAST(0x00009D1501234CC5 AS DateTime), CAST(0x00009D1501234CC5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (140, N'me', N'Montenegro', 1, CAST(0x00009D1501234CC5 AS DateTime), CAST(0x00009D1501234CC5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (141, N'mg', N'Madagascar', 1, CAST(0x00009D1501234CC5 AS DateTime), CAST(0x00009D1501234CC5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (142, N'mh', N'Marshall Islands', 1, CAST(0x00009D1501234CC5 AS DateTime), CAST(0x00009D1501234CC5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (143, N'mk', N'The former Yugoslav Republic of Macedonia', 1, CAST(0x00009D1501234CC6 AS DateTime), CAST(0x00009D1501234CC6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (144, N'ml', N'Mali', 1, CAST(0x00009D1501234CC6 AS DateTime), CAST(0x00009D1501234CC6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (145, N'mm', N'Myanmar', 1, CAST(0x00009D1501234CC6 AS DateTime), CAST(0x00009D1501234CC6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (146, N'mn', N'Mongolia', 1, CAST(0x00009D1501234CC6 AS DateTime), CAST(0x00009D1501234CC6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (147, N'mo', N'Macau', 1, CAST(0x00009D1501234CC6 AS DateTime), CAST(0x00009D1501234CC6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (148, N'mp', N'Northern Mariana Islands', 1, CAST(0x00009D1501234CC6 AS DateTime), CAST(0x00009D1501234CC6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (149, N'mq', N'Martinique (French)', 1, CAST(0x00009D1501234CC6 AS DateTime), CAST(0x00009D1501234CC6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (150, N'mr', N'Mauritania', 1, CAST(0x00009D1501234CC6 AS DateTime), CAST(0x00009D1501234CC6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (151, N'ms', N'Montserrat', 1, CAST(0x00009D1501234CC6 AS DateTime), CAST(0x00009D1501234CC6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (152, N'mt', N'Malta', 1, CAST(0x00009D1501234CC7 AS DateTime), CAST(0x00009D1501234CC7 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (153, N'mu', N'Mauritius', 1, CAST(0x00009D1501234CC7 AS DateTime), CAST(0x00009D1501234CC7 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (154, N'mv', N'Maldives', 1, CAST(0x00009D1501234CC7 AS DateTime), CAST(0x00009D1501234CC7 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (155, N'mw', N'Malawi', 1, CAST(0x00009D1501234CC7 AS DateTime), CAST(0x00009D1501234CC7 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (156, N'mx', N'Mexico', 1, CAST(0x00009D1501234CC7 AS DateTime), CAST(0x00009D1501234CC7 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (157, N'my', N'Malaysia', 1, CAST(0x00009D1501234CC7 AS DateTime), CAST(0x00009D1501234CC7 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (158, N'mz', N'Mozambique', 1, CAST(0x00009D1501234CC7 AS DateTime), CAST(0x00009D1501234CC7 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (159, N'na', N'Namibia', 1, CAST(0x00009D1501234CC7 AS DateTime), CAST(0x00009D1501234CC7 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (160, N'nc', N'New Caledonia', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (161, N'ne', N'Niger', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (162, N'nf', N'Norfolk Island', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (163, N'ng', N'Nigeria', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (164, N'ni', N'Nicaragua', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (165, N'nl', N'Netherlands', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (166, N'no', N'Norway', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (167, N'np', N'Nepal', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (168, N'nr', N'Nauru', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (169, N'nt', N'Neutral Zone', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (170, N'nu', N'Niue', 1, CAST(0x00009D1501234CC8 AS DateTime), CAST(0x00009D1501234CC8 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (171, N'nz', N'New Zealand', 1, CAST(0x00009D1501234CCA AS DateTime), CAST(0x00009D1501234CCA AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (172, N'om', N'Oman', 1, CAST(0x00009D1501234CCA AS DateTime), CAST(0x00009D1501234CCA AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (173, N'pa', N'Panama', 1, CAST(0x00009D1501234CCA AS DateTime), CAST(0x00009D1501234CCA AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (174, N'pe', N'Peru', 1, CAST(0x00009D1501234CCA AS DateTime), CAST(0x00009D1501234CCA AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (175, N'pf', N'Polynesia (French)', 1, CAST(0x00009D1501234CCA AS DateTime), CAST(0x00009D1501234CCA AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (176, N'pg', N'Papua New Guinea', 1, CAST(0x00009D1501234CCA AS DateTime), CAST(0x00009D1501234CCA AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (177, N'ph', N'Philippines', 1, CAST(0x00009D1501234CCA AS DateTime), CAST(0x00009D1501234CCA AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (178, N'pk', N'Pakistan', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (179, N'pl', N'Poland', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (180, N'pm', N'Saint Pierre and Miquelon (French)', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (181, N'pn', N'Pitcairn Island', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (182, N'pr', N'Puerto Rico', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (183, N'ps', N'Palestine', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (184, N'pt', N'Portugal', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (185, N'pw', N'Palau', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (186, N'py', N'Paraguay', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (187, N'qa', N'Qatar', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (188, N'qc', N'Quebec', 1, CAST(0x00009D1501234CCB AS DateTime), CAST(0x00009D1501234CCB AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (189, N're', N'Reunion', 1, CAST(0x00009D1501234CCC AS DateTime), CAST(0x00009D1501234CCC AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (190, N'ro', N'Romania', 1, CAST(0x00009D1501234CCC AS DateTime), CAST(0x00009D1501234CCC AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (191, N'ru', N'Russian Federation', 1, CAST(0x00009D1501234CCC AS DateTime), CAST(0x00009D1501234CCC AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (192, N'rw', N'Rwanda', 1, CAST(0x00009D1501234CCC AS DateTime), CAST(0x00009D1501234CCC AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (193, N'sa', N'Saudi Arabia', 1, CAST(0x00009D1501234CCC AS DateTime), CAST(0x00009D1501234CCC AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (194, N'sb', N'Solomon Islands', 1, CAST(0x00009D1501234CCC AS DateTime), CAST(0x00009D1501234CCC AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (195, N'sc', N'Seychelles', 1, CAST(0x00009D1501234CCC AS DateTime), CAST(0x00009D1501234CCC AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (196, N'sd', N'Sudan', 1, CAST(0x00009D1501234CCC AS DateTime), CAST(0x00009D1501234CCC AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (197, N'se', N'Sweden', 1, CAST(0x00009D1501234CCD AS DateTime), CAST(0x00009D1501234CCD AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (198, N'sg', N'Singapore', 1, CAST(0x00009D1501234CCD AS DateTime), CAST(0x00009D1501234CCD AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (199, N'sh', N'Saint Helen', 1, CAST(0x00009D1501234CCD AS DateTime), CAST(0x00009D1501234CCD AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (200, N'si', N'Slovenia', 1, CAST(0x00009D1501234CCD AS DateTime), CAST(0x00009D1501234CCD AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (201, N'sj', N'Svalbard and Jan Mayen Islands', 1, CAST(0x00009D1501234CCD AS DateTime), CAST(0x00009D1501234CCD AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (202, N'sk', N'Slovakia', 1, CAST(0x00009D1501234CCD AS DateTime), CAST(0x00009D1501234CCD AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (203, N'sl', N'Sierra Leone', 1, CAST(0x00009D1501234CCD AS DateTime), CAST(0x00009D1501234CCD AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (204, N'sm', N'San Marino', 1, CAST(0x00009D1501234CCD AS DateTime), CAST(0x00009D1501234CCD AS DateTime), NULL, NULL)
GO
print 'Processed 200 total records'
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (205, N'sn', N'Senegal', 1, CAST(0x00009D1501234CCD AS DateTime), CAST(0x00009D1501234CCD AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (206, N'so', N'Somalia', 1, CAST(0x00009D1501234CCE AS DateTime), CAST(0x00009D1501234CCE AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (207, N'sr', N'Suriname', 1, CAST(0x00009D1501234CCE AS DateTime), CAST(0x00009D1501234CCE AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (208, N'st', N'Sao Tome and Principe', 1, CAST(0x00009D1501234CCE AS DateTime), CAST(0x00009D1501234CCE AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (209, N'sv', N'El Salvador', 1, CAST(0x00009D1501234CCE AS DateTime), CAST(0x00009D1501234CCE AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (210, N'sy', N'Syrian Arab Republic', 1, CAST(0x00009D1501234CCE AS DateTime), CAST(0x00009D1501234CCE AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (211, N'sz', N'Swaziland', 1, CAST(0x00009D1501234CCF AS DateTime), CAST(0x00009D1501234CCF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (212, N'tc', N'Turks and Caicos Islands (British)', 1, CAST(0x00009D1501234CCF AS DateTime), CAST(0x00009D1501234CCF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (213, N'td', N'Chad', 1, CAST(0x00009D1501234CCF AS DateTime), CAST(0x00009D1501234CCF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (214, N'tf', N'French Southern Territories', 1, CAST(0x00009D1501234CCF AS DateTime), CAST(0x00009D1501234CCF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (215, N'tg', N'Togo', 1, CAST(0x00009D1501234CCF AS DateTime), CAST(0x00009D1501234CCF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (216, N'th', N'Thailand', 1, CAST(0x00009D1501234CCF AS DateTime), CAST(0x00009D1501234CCF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (217, N'tj', N'Tajikistan', 1, CAST(0x00009D1501234CCF AS DateTime), CAST(0x00009D1501234CCF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (218, N'tk', N'Tokelau', 1, CAST(0x00009D1501234CCF AS DateTime), CAST(0x00009D1501234CCF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (219, N'tl', N'Timor-Leste', 1, CAST(0x00009D1501234CCF AS DateTime), CAST(0x00009D1501234CCF AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (220, N'tm', N'Turkmenistan', 1, CAST(0x00009D1501234CD0 AS DateTime), CAST(0x00009D1501234CD0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (221, N'tn', N'Tunisia', 1, CAST(0x00009D1501234CD0 AS DateTime), CAST(0x00009D1501234CD0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (222, N'to', N'Tonga', 1, CAST(0x00009D1501234CD0 AS DateTime), CAST(0x00009D1501234CD0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (223, N'tr', N'Turkey', 1, CAST(0x00009D1501234CD0 AS DateTime), CAST(0x00009D1501234CD0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (224, N'tt', N'Trinidad and Tobago', 1, CAST(0x00009D1501234CD0 AS DateTime), CAST(0x00009D1501234CD0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (225, N'tv', N'Tuvalu', 1, CAST(0x00009D1501234CD0 AS DateTime), CAST(0x00009D1501234CD0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (226, N'tw', N'Taiwan', 1, CAST(0x00009D1501234CD0 AS DateTime), CAST(0x00009D1501234CD0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (227, N'tz', N'United Republic of Tanzania', 1, CAST(0x00009D1501234CD0 AS DateTime), CAST(0x00009D1501234CD0 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (228, N'ua', N'Ukraine', 1, CAST(0x00009D1501234CD1 AS DateTime), CAST(0x00009D1501234CD1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (229, N'ug', N'Uganda', 1, CAST(0x00009D1501234CD1 AS DateTime), CAST(0x00009D1501234CD1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (230, N'um', N'USA Minor Outlying Islands', 1, CAST(0x00009D1501234CD1 AS DateTime), CAST(0x00009D1501234CD1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (231, N'us', N'United States of America', 1, CAST(0x00009D1501234CD1 AS DateTime), CAST(0x00009D1501234CD1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (232, N'uy', N'Uruguay', 1, CAST(0x00009D1501234CD1 AS DateTime), CAST(0x00009D1501234CD1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (233, N'uz', N'Uzbekistan', 1, CAST(0x00009D1501234CD1 AS DateTime), CAST(0x00009D1501234CD1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (234, N'va', N'Holy See', 1, CAST(0x00009D1501234CD1 AS DateTime), CAST(0x00009D1501234CD1 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (235, N'vc', N'Saint Vincent and the Grenadines', 1, CAST(0x00009D1501234CD2 AS DateTime), CAST(0x00009D1501234CD2 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (236, N've', N'Venezuela', 1, CAST(0x00009D1501234CD4 AS DateTime), CAST(0x00009D1501234CD4 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (237, N'vg', N'Virgin Islands (British)', 1, CAST(0x00009D1501234CD5 AS DateTime), CAST(0x00009D1501234CD5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (238, N'vi', N'Virgin islands (USA)', 1, CAST(0x00009D1501234CD5 AS DateTime), CAST(0x00009D1501234CD5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (239, N'vn', N'Viet Nam', 1, CAST(0x00009D1501234CD5 AS DateTime), CAST(0x00009D1501234CD5 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (240, N'vu', N'Vanuatu', 1, CAST(0x00009D1501234CD6 AS DateTime), CAST(0x00009D1501234CD6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (241, N'wf', N'Wallis and Futuna Islands', 1, CAST(0x00009D1501234CD6 AS DateTime), CAST(0x00009D1501234CD6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (242, N'ws', N'Samoa', 1, CAST(0x00009D1501234CD6 AS DateTime), CAST(0x00009D1501234CD6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (243, N'ye', N'Yemen', 1, CAST(0x00009D1501234CD6 AS DateTime), CAST(0x00009D1501234CD6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (244, N'yt', N'Mayotte', 1, CAST(0x00009D1501234CD6 AS DateTime), CAST(0x00009D1501234CD6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (245, N'za', N'South Africa', 1, CAST(0x00009D1501234CD6 AS DateTime), CAST(0x00009D1501234CD6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (246, N'zm', N'Zambia', 1, CAST(0x00009D1501234CD6 AS DateTime), CAST(0x00009D1501234CD6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (247, N'zw', N'Zimbabwe', 1, CAST(0x00009D1501234CD6 AS DateTime), CAST(0x00009D1501234CD6 AS DateTime), NULL, NULL)
INSERT [dbo].[Country] ([Id], [Code], [Description], [Status], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy]) VALUES (248, N'gb', N'United Kingdom of Great Britain and Northern Ireland', 1, CAST(0x00009D150123DBF0 AS DateTime), CAST(0x00009D150123DBF0 AS DateTime), NULL, NULL)

INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (34, 154, CAST(0x0000962900000000 AS DateTime), CAST(0x0000979F00000000 AS DateTime), N'Sr. .Net Developer', 4, 1, 1, N'P12,000', N'P12,000', N'Design websites for company using Adobe dreamweaver, Flash and other web applications.', N'sample reason for leaving', N'Appsource', N'Information Technology', N'Unit 1401 Robinsons Equit', N'ADB Ave. Corner Poveda Ro', N'Pasig', N'NCR', N'NCR', 177, N'') INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (35, 154, CAST(0x0000990900000000 AS DateTime), CAST(0x00009A7700000000 AS DateTime), N'Lead Software Developer', 4, 2, 1, N'P12,000', N'P12,000', N'Design websites for company using Adobe dreamweaver, Flash and other web applications.', N'sample reason for leaving', N'Corebuilt Technologies', N'Information Technology', N'24/F 88 Corporate Center', N'Valero St.,', N'Makati', N'NCr', N'NCr', 177, N'') INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (36, 154, CAST(0x00009A7700000000 AS DateTime), NULL, N'Web Developer', 4, 1, 1, N'P15,000', N'P15,000', N'sample description', N'sample description', N'IDCSI', N'Information Technology', N'15/F Summit One Tower', N'530 Shaw Blvd.,', N'Mandaluyong', N'', N'NCR', 177, N'') INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (38, 155, CAST(0x00009AB900000000 AS DateTime), CAST(0x00009C2600000000 AS DateTime), N'Analyst', 4, 3, 1, N'P15,000', N'P15,000', N'sample description', N'sample description', N'IDCSI', N'Information Technology', N'15/F Summit One Tower', N'530 Shaw Blvd.,', N'Mandaluyong', NULL, NULL, 177, NULL) INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (40, 156, CAST(0x000090EE00000000 AS DateTime), CAST(0x00009CF100000000 AS DateTime), N'Quality Controller', 4, 2, 1, N'P15,000', N'P15,000', N'sample description', N'sample description', N'IDCSI', N'Information Technology', N'15/F Summit One Tower', N'530 Shaw Blvd.,', N'Mandaluyong', N'', N'', 177, N'') INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (41, 165, CAST(0x0000722E00000000 AS DateTime), CAST(0x0000882800000000 AS DateTime), N'Analyst', 4, 2, 1, N'P15,000', N'P15,000', N'sample description', N'sample description', N'Microsoft', N'Information Technology', N'15/F Summit One Tower', N'530 Shaw Blvd.,', N'Mandaluyong', NULL, NULL, 177, NULL) INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (42, 165, CAST(0x0000885F00000000 AS DateTime), CAST(0x00009CF100000000 AS DateTime), N'Programmer', 4, 3, 1, N'P15,000', N'P15,000', N'sample description', N'sample description', N'Microsoft', N'Information Technology', N'15/F Summit One Tower', N'530 Shaw Blvd.,', N'Mandaluyong', N'', N'', 177, N'') INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (44, 166, CAST(0x0000902700000000 AS DateTime), CAST(0x00009CFE00000000 AS DateTime), N'Programmer', 4, 1, 1, N'P15,000', N'P15,000', N'sample description', N'sample description', N'Microsoft', N'Information Technology', N'15/F Summit One Tower', N'530 Shaw Blvd.,', N'Mandaluyong', NULL, NULL, 177, NULL) INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (45, 168, CAST(0x0000887E00000000 AS DateTime), CAST(0x00009B0B00000000 AS DateTime), N'Analyst', 4, 2, 1, N'P15,000', N'P15,000', N'sample description', N'sample description', N'Microsoft', N'Information Technology', N'15/F Summit One Tower', N'530 Shaw Blvd.,', N'Mandaluyong', NULL, NULL, 177, NULL) INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (47, 170, CAST(0x00009D3C00000000 AS DateTime), NULL, N'Web Developer', 4, 2, 1, N'P15,000', N'P15,000', N'sample description', N'sample description', N'Microsoft', N'Information Technology', N'15/F Summit One Tower', N'530 Shaw Blvd.,', N'Mandaluyong', NULL, NULL, 177, NULL) INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (48, 156, CAST(0x00009A7300000000 AS DateTime), CAST(0x00009BE500000000 AS DateTime), N'', 4, 2, 1, N'P34,343', N'P3,434', N'fgf', N'fgfggf', N'fgfg', N'Information Technology', N'fgfg', N'fgfg', N'fgfg', N'fgfgf', N'fgfg', 177, N'4545') INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (49, 156, CAST(0x00009BDF00000000 AS DateTime), CAST(0x00009C4700000000 AS DateTime), N'', 4, 1, 1, N'P343', N'P344,343', N'dfdf', N'dfdf', N'dfdfd', N'Information Technology', N'ff', N'', N'dffd', N'', N'', 177, N'') INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (51, 168, CAST(0x00009D7200000000 AS DateTime), NULL, N'Business Analyst', 4, 1, 1, N'P3,434', N'P33,333', N'3434', N'3434', N'dsd', N'Information Technology', N'sdsds', N'', N'sdsd', N'', N'', 177, N'') INSERT [dbo].[EmploymentDetails] ([Id], [aId], [Startdate], [Enddate], [Position], [PositionLevelId], [SpecializationId], [PositionId], [StartSalary], [EndSalary], [DescriptionofDuties], [ReasonforLeaving], [CompanyName], [TypeofBusiness], [Address1], [Address2], [City], [Province], [StateorRegion], [CountryId], [PostalCode]) VALUES (52, 168, CAST(0x00009D6B00000000 AS DateTime), CAST(0x00009D7200000000 AS DateTime), N'Analyst Programmer', 4, 1, 1, N'P43,434', N'P434,343', N'4', N'344', N'3434', N'Information Technology', N'434', N'', N'3434', N'', N'', 177, N'')

INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (1, 0, N'admin', N'user', N'admin', N'uVMYLEgn', N'admin', N'rene_floren@yahoo.com.ph', N'crisgomez08@yahoo.com.com', 1, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (154, 0, N'Gregorio', N'Honasan', N'Pimentel', N'uVMYLEgn/uVMYLEgn==', N'gregorio', N'crisgomez08@yahoo.com', N'curlybub26@gmail.com', 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (155, 0, N'Harry', N'Nasino', NULL, N'v46uVMYLEgnLEgnVcD5qw==', N'curlybub26', N'curlybub26@gmail.com', N'curlybub26@gmail.com', 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (156, 0, N'Qwerty', N'Qazggf', N'fgfgf', N'v46huVMYLEgnMYLEgnVcD5qw==', N'qwertyqaz', N'rencrisgomez08@yahoo.com', N'rcurlybub26@gmail.com', 0, 0)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (165, 0, N'Pedro', N'Juaquin', N'', N'v46hD6uVMYLEgngnVcD5qw==', N'qqqqq1', N'crisgomez08@yahoo.com.ph', N'crisgomez08@yahoo.com.ph', 0, 0)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (166, 0, N'Joseph', N'Baldiramma', NULL, N'v46hDuVMYLEgnYLEgnVcD5qw==', N'qqqqq2', N'rene_florendo2005', N'crisgomez08@yahoo.com', 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (168, 0, N'Nicanor', N'dela cruz', N'Perlas', N'v46huVMYLEgn5gSwetbh9w==', N'qqqqq3', N'crisgomez08@yahoo.com', N'rcurlybub26@gmail.com', 3, 0)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (170, 0, N'Juan', N'Enrile', NULL, N'v46hD6uVMYLEgnEgnVcD5qw==', N'qqqqq4', N'crisgomez08@yahoo.com', N'curlybub26@gmail.com', 2, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (172, 0, N'Joseph', N'Estrada', N'', N'v46hD6uVMYLEgnLEgnVcD5qw==', N'qqqqq5', N'crisgomez08@yahoo.com', N'curlybub26@gmail.com', 2, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (176, 0, N'Ramon', N'MAgsaysay', N'', N'v46hDVMYLEVMYLEgnVcD5qw==', N'qqqqq6', N'crisgomez08@yahoo.com', N'curlybub26@gmail.com', 1, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (182, 0, N'Sebastian', N'Agapito', NULL, N'gMtIVMYLEG3e2FCMQ==', N'harrynaua', N'crisgomez08@yahoo.com', NULL, 2, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (183, 0, N'Samuel', N'Lagmay', NULL, N'v46hD68VMYLEYLEgnVcD5qw==', N'poiuytrewq', N'crisgomez08@yahoo.com', NULL, 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (184, 0, N'Xandrick', N'Florendo', NULL, N'v46hD6VMYLEYLEgnVcD5qw==', N'qwertyqaz1', N'crisgomez08@yahoo.com', NULL, 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (186, 0, N'Cris', N'Gomez', NULL, N'v46hD6VMYLEYLEgnVcD5qw==', N'juan1234', N'crisgomez08@yahoo.com', NULL, 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (187, 0, N'Greg', N'Untalan', NULL, N'v46hD6VMYLEYLEgnVcD5qw==', N'greg_untalan', N'crisgomez08@yahoo.com', NULL, 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (188, 0, N'Harrie', N'Minnetes', N'Daligdig ', N'85G1KVMYLEoKuQtgF4c6g==', N'harba', N'crisgomez08@yahoo.com.biz', N'curlybub26@gmail.com', 3, 0)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (189, 0, N'Michael', N'Detras', NULL, N'NEHMAQM0GGs5KVMYLEEehgsSCdVwPmr', N'mdetras', N'crisgomez08@yahoo.com.biz', NULL, 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (190, 0, N'Jewelyn', N'Catang-catang', NULL, N'ljEQUVMYLEoAhSDig==', N'jdccgub', N'crisgomez08@yahoo.com.com.ph', NULL, 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (192, 0, N'ForTesting', N'Only', NULL, N'v46hD6VMYLEEgnVcD5qw==', N'fortestingonly', N'crisgomez08@yahoo.com.com', NULL, 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (193, 0, N'oneal', N'o''neal sd', NULL, N'v46hDVMYLEgnVcD5qw==', N'mytesting', N'crisgomez08@yahoo.com.com', NULL, 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (194, 0, N'Fernando', N'Montiel', NULL, N'v46hDVMYLEEgnVcD5qw==', N'fernando_montiel', N'crisgomez08@yahoo.com.com', NULL, 3, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (209, 172, N'Nonito', N'Donaire', NULL, N'v46hD6VMYLELEgnVcD5qw==', N'nonito_donaire', N'greg.untalan@yahoo.com', NULL, 4, 1)
INSERT [dbo].[Users] ([Id], [ParentId], [Firstname], [Lastname], [Middlename], [EncryptPassword], [Username], [Email], [AlternativeEmail], [RoleId], [UserStatusId]) VALUES (210, 172, N'rez', N'floro', NULL, N'v46hDVMYLEEgnVcD5qw==', N'rflo', N'crisgomez08@yahoo.com.com', NULL, 4, 1)

INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (11, 154, 172, 2, CAST(0x00009D7400B08DA9 AS DateTime), CAST(0x00009D8B00A6565F AS DateTime), 172, 172, 1)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (13, 155, 172, 1, CAST(0x00009D5F0118CCA4 AS DateTime), CAST(0x00009D8B0099D532 AS DateTime), 172, 172, 1)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (14, 154, 170, 2, CAST(0x00009E4A00000000 AS DateTime), CAST(0x00009E4A00000000 AS DateTime), 27, 27, 1)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (15, 154, 171, 3, CAST(0x00009E4A00000000 AS DateTime), CAST(0x00009E4A00000000 AS DateTime), 27, 27, 1)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (16, 165, 172, 1, CAST(0x00009D5F01194C7A AS DateTime), CAST(0x00009D5F01194C7A AS DateTime), 1, 1, NULL)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (17, 166, 172, 5, CAST(0x00009D730103A3A1 AS DateTime), CAST(0x00009D730103A3D8 AS DateTime), 172, 172, NULL)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (18, 168, 172, 2, CAST(0x00009D870116B19D AS DateTime), CAST(0x00009D870116B19D AS DateTime), 172, 172, NULL)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (19, 184, 172, 2, CAST(0x00009DB100DD5113 AS DateTime), CAST(0x00009DB100DD5113 AS DateTime), 172, 172, NULL)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (20, 190, 172, 2, CAST(0x00009DB800A62F8E AS DateTime), CAST(0x00009DB800A62F8E AS DateTime), 172, 172, NULL)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (21, 191, 172, 2, CAST(0x00009DB4010781F9 AS DateTime), CAST(0x00009DB4010781F9 AS DateTime), 172, 172, NULL)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (22, 190, 168, 2, CAST(0x00009DB500AADC4C AS DateTime), CAST(0x00009DB500AADC4C AS DateTime), 168, 168, NULL)
INSERT [dbo].[ApplicationStatus] ([Id], [aId], [cId], [APStatusId], [DateCreated], [DateUpdated], [Createdby], [UpdatedBy], [sId]) VALUES (24, 191, 168, 2, CAST(0x00009DB500AAF19A AS DateTime), CAST(0x00009DB500AAF19A AS DateTime), 168, 168, NULL)

create table ClientDetails( Id bigint not null identity constraint PK_ClientDetails primary key, Companyname nvarchar(150) not null, Industry int not null, TypeofCompany int not null, Address1 nvarchar(100), Address2 nvarchar(100), City varchar(25), Province varchar(25), StateorRegion varchar(25), Country int, Telephoneno varchar(50), fax varchar(50), NoofEmployees int, Website varchar(100), Overview nvarchar(2000), History nvarchar(2000), ProductandServices nvarchar(2000), Financial nvarchar(2000), Cultureandvalues nvarchar(2000), Benefits nvarchar(1000), OtherInformation nvarchar(2000), uId bigint not null, mobileno varchar(50), remarks nvarchar(150) ) go

INSERT [dbo].[ClientDetails] ([Id], [Companyname], [Industry], [TypeofCompany], [Address1], [Address2], [City], [Province], [StateorRegion], [Country], [Telephoneno], [fax], [NoofEmployees], [Website], [Overview], [History], [ProductandServices], [Financial], [Cultureandvalues], [Benefits], [OtherInformation], [uId], [mobileno], [remarks]) VALUES (4, N'dfdf', 21, 3, N'df', N'', N'dfdfd', N'', N'', 177, N'(3434)343-4343', N'(343)343-4343', 0, N'', N'', N'', N'', N'', N'', N'', N'', 208, NULL, NULL)
INSERT [dbo].[ClientDetails] ([Id], [Companyname], [Industry], [TypeofCompany], [Address1], [Address2], [City], [Province], [StateorRegion], [Country], [Telephoneno], [fax], [NoofEmployees], [Website], [Overview], [History], [ProductandServices], [Financial], [Cultureandvalues], [Benefits], [OtherInformation], [uId], [mobileno], [remarks]) VALUES (5, N'sds sdsd', 24, 2, N' sds ds', N'', N'sd sdsd', N'', N'', 177, N'(232)232-3232', N'(3232)232-3232', 0, N'', N'', N'', N'', N'', N'', N'', N'', 209, NULL, NULL)
INSERT [dbo].[ClientDetails] ([Id], [Companyname], [Industry], [TypeofCompany], [Address1], [Address2], [City], [Province], [StateorRegion], [Country], [Telephoneno], [fax], [NoofEmployees], [Website], [Overview], [History], [ProductandServices], [Financial], [Cultureandvalues], [Benefits], [OtherInformation], [uId], [mobileno], [remarks]) VALUES (6, N'xxxxxx', 7, 4, N'xxx', N'xxx', N'xxx', N'', N'', 177, N'(334)434-3434', N'(33)343-4434', 0, N'', N'', N'', N'', N'', N'', N'', N'', 210, NULL, NULL)

create table Specialization( Id bigint not null identity constraint PK_Specialization primary key, Code varchar(10) not null, Description varchar(100) not null, DateCreated datetime not null, DateUpdated datetime not null, CreatedBy bigint, UpdatedBy bigint, Status int not null ) go

INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (1, N'ASC', N'Actuarial Science/Statistics', CAST(0x00009D4200B4C928 AS DateTime), CAST(0x00009D4200B4C928 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (2, N'AMP', N'Advertising/Media Planning', CAST(0x00009D4200B4C929 AS DateTime), CAST(0x00009D4200B4C929 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (3, N'AFF', N'Agriculture/Forestry/Fisheries', CAST(0x00009D4200B4C929 AS DateTime), CAST(0x00009D4200B4C929 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (4, N'AID', N'Architecture/Interior Design', CAST(0x00009D4200B4C92A AS DateTime), CAST(0x00009D4200B4C92A AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (5, N'ACGD', N'Arts/Creative/Graphics Design', CAST(0x00009D4200B4C92A AS DateTime), CAST(0x00009D4200B4C92A AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (6, N'AIM', N'Aviation/Aircraft Maintenance', CAST(0x00009D4200B4C92A AS DateTime), CAST(0x00009D4200B4C92A AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (7, N'BFS', N'Banking/Financial Services', CAST(0x00009D4200B4C92B AS DateTime), CAST(0x00009D4200B4C92B AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (8, N'BIO', N'Biotechnology', CAST(0x00009D4200B4C92B AS DateTime), CAST(0x00009D4200B4C92B AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (9, N'CHEM', N'Chemistry', CAST(0x00009D4200B4C92C AS DateTime), CAST(0x00009D4200B4C92C AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (10, N'CAS', N'Clerical/Administrative Support', CAST(0x00009D4200B4C92C AS DateTime), CAST(0x00009D4200B4C92C AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (11, N'CSTM', N'Corporate Strategy/Top Management', CAST(0x00009D4200B4C92C AS DateTime), CAST(0x00009D4200B4C92C AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (12, N'CS', N'Customer Service', CAST(0x00009D4200B4C92D AS DateTime), CAST(0x00009D4200B4C92D AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (13, N'EDU', N'Education', CAST(0x00009D4200B4C92D AS DateTime), CAST(0x00009D4200B4C92D AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (14, N'EC', N'Engineering - Chemical', CAST(0x00009D4200B4C92D AS DateTime), CAST(0x00009D4200B4C92D AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (15, N'ECCS', N'Engineering - Civil/Construction/Structural', CAST(0x00009D4200B4C92D AS DateTime), CAST(0x00009D4200B4C92D AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (16, N'EE', N'Engineering - Electrical', CAST(0x00009D4200B4C92E AS DateTime), CAST(0x00009D4200B4C92E AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (17, N'EEC', N'Engineering - Electronics/Communication', CAST(0x00009D4200B4C92E AS DateTime), CAST(0x00009D4200B4C92E AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (18, N'EEHS', N'Engineering - Environmental/Health/Safety', CAST(0x00009D4200B4C92E AS DateTime), CAST(0x00009D4200B4C92E AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (19, N'EI', N'Engineering - Industrial', CAST(0x00009D4200B4C92F AS DateTime), CAST(0x00009D4200B4C92F AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (20, N'EMA', N'Engineering - Mechanical/Automotive', CAST(0x00009D4200B4C92F AS DateTime), CAST(0x00009D4200B4C92F AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (21, N'EOG', N'Engineering - Oil/Gas', CAST(0x00009D4200B4C92F AS DateTime), CAST(0x00009D4200B4C92F AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (22, N'EOG', N'Engineering - Others', CAST(0x00009D4200B4C930 AS DateTime), CAST(0x00009D4200B4C930 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (23, N'EPA', N'Entertainment/Performing Arts', CAST(0x00009D4200B4C930 AS DateTime), CAST(0x00009D4200B4C930 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (24, N'FAT', N'Finance - Audit/Taxation', CAST(0x00009D4200B4C930 AS DateTime), CAST(0x00009D4200B4C930 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (25, N'FCFIM', N'Finance - Corporate Finance/Investment/Merchant Banking', CAST(0x00009D4200B4C930 AS DateTime), CAST(0x00009D4200B4C930 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (26, N'FGCA', N'Finance - General/Cost Accounting ', CAST(0x00009D4200B4C931 AS DateTime), CAST(0x00009D4200B4C931 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (27, N'FTN', N'Food Technology/Nutritionist', CAST(0x00009D4200B4C931 AS DateTime), CAST(0x00009D4200B4C931 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (28, N'FBRS', N'Food/Beverage/Restaurant Service', CAST(0x00009D4200B4C932 AS DateTime), CAST(0x00009D4200B4C932 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (29, N'GW', N'General Work (Housekeeper, Driver, Dispatch, Messenger, etc)', CAST(0x00009D4200B4C932 AS DateTime), CAST(0x00009D4200B4C932 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (30, N'GG', N'Geology/Geophysics', CAST(0x00009D4200B4C932 AS DateTime), CAST(0x00009D4200B4C932 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (31, N'HDD', N'Healthcare - Doctor/Diagnosis', CAST(0x00009D4200B4C933 AS DateTime), CAST(0x00009D4200B4C933 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (32, N'HMSA', N'Healthcare - Nurse/Medical Support & Assistant', CAST(0x00009D4200B4C933 AS DateTime), CAST(0x00009D4200B4C933 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (33, N'HP', N'Healthcare - Pharmacy', CAST(0x00009D4200B4C933 AS DateTime), CAST(0x00009D4200B4C933 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (34, N'HMTS', N'Hotel Management/Tourism Services', CAST(0x00009D4200B4C933 AS DateTime), CAST(0x00009D4200B4C933 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (35, N'HR', N'Human Resources', CAST(0x00009D4200B4C934 AS DateTime), CAST(0x00009D4200B4C934 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (36, N'ITCH', N'IT/Computer - Hardware', CAST(0x00009D4200B4C934 AS DateTime), CAST(0x00009D4200B4C934 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (37, N'ITCN', N'IT/Computer - Network/System/Database Admin', CAST(0x00009D4200B4C934 AS DateTime), CAST(0x00009D4200B4C934 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (38, N'ITS', N'IT/Computer - Software', CAST(0x00009D4200B4C935 AS DateTime), CAST(0x00009D4200B4C935 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (39, N'JE', N'Journalist/Editor', CAST(0x00009D4200B4C935 AS DateTime), CAST(0x00009D4200B4C935 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (40, N'LLS', N'Law/Legal Services', CAST(0x00009D4200B4C935 AS DateTime), CAST(0x00009D4200B4C935 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (41, N'LSC', N'Logistics/Supply Chain', CAST(0x00009D4200B4C936 AS DateTime), CAST(0x00009D4200B4C936 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (42, N'MR', N'Maintenance/Repair (Facilities & Machinery)', CAST(0x00009D4200B4C936 AS DateTime), CAST(0x00009D4200B4C936 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (43, N'MPO', N'Manufacturing/Production Operations', CAST(0x00009D4200B4C936 AS DateTime), CAST(0x00009D4200B4C936 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (44, N'MBD', N'Marketing/Business Development', CAST(0x00009D4200B4C937 AS DateTime), CAST(0x00009D4200B4C937 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (45, N'MER', N'Merchandising', CAST(0x00009D4200B4C937 AS DateTime), CAST(0x00009D4200B4C937 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (46, N'PCBFS', N'Personal Care/Beauty/Fitness Service', CAST(0x00009D4200B4C937 AS DateTime), CAST(0x00009D4200B4C937 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (47, N'PDCI', N'Process Design & Control/Instrumentation', CAST(0x00009D4200B4C938 AS DateTime), CAST(0x00009D4200B4C938 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (48, N'PRE', N'Property/Real Estate', CAST(0x00009D4200B4C938 AS DateTime), CAST(0x00009D4200B4C938 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (49, N'PRC', N'Public Relations/Communications', CAST(0x00009D4200B4C938 AS DateTime), CAST(0x00009D4200B4C938 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (50, N'PPP', N'Publishing/Printing140">Purchasing/Inventory/Material & Warehouse Management', CAST(0x00009D4200B4C939 AS DateTime), CAST(0x00009D4200B4C939 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (51, N'QCA', N'Quality Control/Assurance', CAST(0x00009D4200B4C939 AS DateTime), CAST(0x00009D4200B4C939 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (52, N'QS', N'Quantity Surveying', CAST(0x00009D4200B4C939 AS DateTime), CAST(0x00009D4200B4C939 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (53, N'SC', N'Sales - Corporate', CAST(0x00009D4200B4C939 AS DateTime), CAST(0x00009D4200B4C939 AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (54, N'SET', N'Sales - Engineering/Technical/IT', CAST(0x00009D4200B4C93A AS DateTime), CAST(0x00009D4200B4C93A AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (55, N'SFS', N'Sales - Financial Services (Insurance, Unit Trust, etc)', CAST(0x00009D4200B4C93A AS DateTime), CAST(0x00009D4200B4C93A AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (56, N'SRG', N'Sales - Retail/General', CAST(0x00009D4200B4C93B AS DateTime), CAST(0x00009D4200B4C93B AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (57, N'STT', N'Sales - Telesales/Telemarketing', CAST(0x00009D4200B4C93B AS DateTime), CAST(0x00009D4200B4C93B AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (58, N'STL', N'Science & Technology/Laboratory', CAST(0x00009D4200B4C93B AS DateTime), CAST(0x00009D4200B4C93B AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (59, N'SEPA', N'Secretarial/Executive & Personal Assistant', CAST(0x00009D4200B4C93C AS DateTime), CAST(0x00009D4200B4C93C AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (60, N'SARRS', N'Security/Armed Forces/Protective Services', CAST(0x00009D4200B4C93C AS DateTime), CAST(0x00009D4200B4C93C AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated], [CreatedBy], [UpdatedBy], [Status]) VALUES (61, N'SCS', N'Social & Counselling Service', CAST(0x00009D4200B4C93C AS DateTime), CAST(0x00009D4200B4C93C AS DateTime), 1, 1, 1)
INSERT [dbo].[Specialization] ([Id], [Code], [Description], [DateCreated], [DateUpdated]

exec [dbo].[Get_Applicant_List] @cId=172,@sId=1,@folderId=2
exec [dbo].[Get_Applicant_List] @cId=172,@sId=38,@folderId=1

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources