Fill the COUNTRY table with predefined values

Today we encountered a need to populate the COUNTRY table with a more or less complete list of countries in the world.

Based on the results of a google search and some find-and-replacing, I came up with the below script.

You’ll get an error on those lines that conflict with any countries that are already in your table.  Those errors can be safely ignored.

Just in case this is useful to someone else, here is the script.  You are free to sing along if you like.

declare @changeagentid uniqueidentifier = null;
declare @countryaddressformatid uniqueidentifier = (select top 1 id from countryaddressformat);
exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @changeagentid output
 
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Afghanistan' as description,'AF' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Albania' as description,'AL' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Algeria' as description,'DZ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Andorra' as description,'AD' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Angola' as description,'AO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Anguilla' as description,'AI' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Antarctica' as description,'AQ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Antigua and Barbuda' as description,'AG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Argentina Republic' as description,'AR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Armenia' as description,'AM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Aruba' as description,'AW' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Australia' as description,'AU' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Austria' as description,'AT' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Azerbaijan' as description,'AZ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Bahamas' as description,'BS' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Bahrain' as description,'BH' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Bangladesh' as description,'BD' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Barbados' as description,'BB' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Belarus' as description,'BY' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Belgium' as description,'BE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Belize' as description,'BZ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Benin' as description,'BJ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Bermuda' as description,'BM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Bhutan' as description,'BT' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Botswana' as description,'BW' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Bouvet Island' as description,'BV' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Bolivia' as description,'BO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Bosnia and Herzegovina' as description,'BA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Brazil' as description,'BR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'British Indian Ocean Territory' as description,'IO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'British Virgin Islands' as description,'VG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Brunei Darussalam' as description,'BN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Bulgaria' as description,'BG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Burkina Faso' as description,'BF' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Burundi' as description,'BI' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Bahamas' as description,'BS' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Cambodia' as description,'KH' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Croatia' as description,'HR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Cameroon' as description,'CM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Canada' as description,'CA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Cape Verde' as description,'CV' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Cayman Islands' as description,'KY' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Central African Republic' as description,'CF' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Chile' as description,'CL' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'China' as description,'CN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Christmas Islands' as description,'CX' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Cocos Islands' as description,'CC' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Colombia' as description,'CO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Comoros' as description,'KM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Congo' as description,'CG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Cook Islands' as description,'CK' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Costa Rica' as description,'CR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Cote D''Ivoire' as description,'CI' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Cyprus' as description,'CY' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Cuba' as description,'CU' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Czech Republic' as description,'CZ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Denmark' as description,'DK' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Djibouti' as description,'DJ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Dominica' as description,'DM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Dominican Republic' as description,'DO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'East Timor' as description,'TP' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Ecuador' as description,'EC' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Egypt' as description,'EG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'El Salvador' as description,'SV' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Estonia' as description,'EE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Equatorial Guinea' as description,'GQ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Ethiopia' as description,'ET' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Falkland Islands' as description,'FK' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Faroe Islands' as description,'FO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Fiji' as description,'FJ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Finland' as description,'FI' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'France' as description,'FR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'French Guiana' as description,'GF' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'French Polynesia' as description,'PF' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'French Southern Territories' as description,'TF' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Gabon' as description,'GA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Gambia' as description,'GM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Georgia' as description,'GE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Germany' as description,'DE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Ghana' as description,'GH' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Gibraltar' as description,'GI' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Greece' as description,'GR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Greenland' as description,'GL' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Grenada' as description,'GD' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Guadeloupe' as description,'GP' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Guam' as description,'GU' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Guatemala' as description,'GT' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Guinea' as description,'GN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Guinea-Bissau' as description,'GW' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Guyana' as description,'GY' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Haiti' as description,'HT' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Heard and McDonald Islands' as description,'HM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Honduras' as description,'HN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Hong Kong' as description,'HK' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Hungary' as description,'HU' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Iceland' as description,'IS' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'India' as description,'IN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Iraq' as description,'IQ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Indonesia' as description,'ID' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Iran' as description,'IR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Ireland' as description,'IE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Israel' as description,'IL' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Italy' as description,'IT' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Jamaica' as description,'JM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Japan' as description,'JP' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Jordan' as description,'JO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Kazakhstan' as description,'KZ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Kenya' as description,'KE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Kiribati' as description,'KI' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Korea (North)' as description,'KP' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Korea (South)' as description,'KR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Kuwait' as description,'KW' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Kyrgyzstan' as description,'KG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Lao' as description,'LA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Latvia' as description,'LV' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Lebanon' as description,'LB' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Lesotho' as description,'LS' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Liberia' as description,'LR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Libyan Arab Jamahiriya' as description,'LY' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Liechtenstein' as description,'LI' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Lithuania' as description,'LT' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Luxembourg' as description,'LU' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Macau' as description,'MO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Macedonia' as description,'MK' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Madagascar' as description,'MG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Malawi' as description,'MW' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Malaysia' as description,'MY' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Maldives' as description,'MV' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Mali' as description,'ML' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Malta' as description,'MT' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Marshall Islands' as description,'MH' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Martinique' as description,'MQ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Mauritania' as description,'MR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Mauritius' as description,'MU' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Mayotte' as description,'YT' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Mexico' as description,'MX' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Mongolia' as description,'MN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Montenegro' as description,'ME' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Montserrat' as description,'MS' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Morocco' as description,'MA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Mozambique' as description,'MZ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Myanmar' as description,'MM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Micronesia' as description,'FM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Monaco' as description,'MC' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Namibia' as description,'NA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Nauru' as description,'NR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Nepal' as description,'NP' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Netherlands Antilles' as description,'AN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'The Netherlands' as description,'NL' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'New Caledonia' as description,'NC' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'New Zealand' as description,'NZ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Nicaragua' as description,'NI' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Niger' as description,'NE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Nigeria' as description,'NG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Niue' as description,'NU' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Norfolk Island' as description,'NF' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Northern Mariana Islands' as description,'MP' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Norway' as description,'No' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Oman' as description,'OM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Panama' as description,'PA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Pakistan' as description,'PK' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Palau' as description,'PW' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Papua New Guinea' as description,'PG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Paraguay' as description,'PY' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Peru' as description,'PE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Philippines' as description,'PH' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Pitcairn' as description,'PN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Poland' as description,'PL' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Portugal' as description,'PT' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Palestine' as description,'PS' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Puerto Rico' as description,'PR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Qatar' as description,'QA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Romania' as description,'RO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Russian Federation' as description,'RU' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Rwanda' as description,'RW' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Samoa' as description,'WS' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'San Marino' as description,'SM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Sao Tome and Principe' as description,'ST' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Saudi Arabia' as description,'SA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Senegal' as description,'SN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Serbia' as description,'SP' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Seychelles' as description,'SC' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Sierra Leone' as description,'SL' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Singapore' as description,'SG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Slovakia' as description,'SK' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Slovenia' as description,'SI' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Solomon Islands' as description,'SB' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Somalia' as description,'SO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'South Africa' as description,'ZA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Spain' as description,'ES' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Sri Lanka' as description,'LK' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'St. Helena' as description,'SH' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'St. Kitts and Nevis' as description,'KN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'St. Lucia' as description,'LC' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'St. Pierre and Miquelon' as description,'PM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'St. Vincent and the Grenadines' as description,'VC' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Sudan' as description,'SD' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Suriname' as description,'SR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Svalbard and Jan Mayen' as description,'SJ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Swaziland' as description,'SZ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Sweden' as description,'SE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Switzerland' as description,'CH' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Syrian Arab Republic' as description,'SY' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Taiwan' as description,'TW' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Tajikistan' as description,'TJ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Tanzania' as description,'TZ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Thailand' as description,'TH' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Togo' as description,'TG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Tokelau' as description,'TK' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Tonga' as description,'TO' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Trinidad and Tobago' as description,'TT' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Tunisia' as description,'TN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Turkey' as description,'TR' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Turkmenistan' as description,'TM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Tuvalu' as description,'TV' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Uganda' as description,'UG' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Ukraine' as description,'UA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'United Arab Emirates' as description,'AE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'United Kingdom' as description,'GB' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'United States' as description,'US' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'U.S. Minor Outlying Islands' as description,'UM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Uruguay' as description,'UY' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Uzbekistan' as description,'UZ' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Vanuatu' as description,'VU' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Venezuela' as description,'VE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Vietnam' as description,'VN' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Virgin Islands (USA)' as description,'VI' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Vatican City State' as description,'VA' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Wallis and Futuna Islands' as description,'WF' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Western Sahara' as description,'EH' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Yemen' as description,'YE' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Yugoslavia' as description,'YU' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Zambia' as description,'ZM' as abbreviation ,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166;
INSERT INTO COUNTRY(DESCRIPTION,ABBREVIATION,ID ,COUNTRYADDRESSFORMATID,ACTIVE,SEQUENCE,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED,USEFORCOAUPDATE,PHONEFORMATCODE,COUNTRYCODE,ISO3166) select 'Zimbabwe' as description,'ZW' as countrycode,newid() as id, @countryaddressformatid as countryaddressformatid, 1 as active, 0 as sequence, @changeagentid as addedbyid, @changeagentid as changedbyid, getdate() as dateadded, getdate() as datechanged, 0 as useforcoaupdate, 0 as phoneformatcode, '' as countrycode, '' as iso3166

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s