2013 UK Counties insert

MVP

Total Posts: 484
Karma: 3953
Joined: 11/12/2010
Location: United Kingdom

Posted: 10 years ago

Hope this might prove useful to others as the only other list of UK counties available is very outdated now.

Below is a new version :)

DECLARE @CountryId INT;

SELECT @CountryId = [Id] FROM [Country] WHERE [TwoLetterIsoCode] = 'GB'

INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Leitrim', 'LET', 1, 1)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Laois', 'LEX', 1, 2)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Kilkenny', 'KIK', 1, 3)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Kildare', 'KID', 1, 4)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Kerry', 'KER', 1, 5)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Galway', 'GAL', 1, 6)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Fermanagh', 'FER', 1, 7)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Dublin', 'DUB', 1, 8)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Down', 'DOW', 1, 9)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Donegal', 'DON', 1, 10)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Cork', 'COR', 1, 11)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Clare', 'CLA', 1, 12)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Cavan', 'CAV', 1, 13)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Carlow', 'CAR', 1, 14)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Armagh', 'ARM', 1, 15)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Antrim', 'ANT', 1, 16)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Clwyd', 'CWD', 1, 17)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cleveland', 'CLV', 1, 18)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Clackmannanshire', 'CLK', 1, 19)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cheshire', 'CHS', 1, 20)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Central', 'CEN', 1, 21)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Carmarthenshir', 'CMN', 1, 22)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cardiganshire', 'CGN', 1, 23)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cambridgeshire', 'CAM', 1, 24)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Caithness', 'CAI', 1, 25)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Caernarvonshire', 'CAE', 1, 26)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Bute', 'BUT', 1, 27)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Buckinghamshire', 'BKM', 1, 28)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Bristol', 'BRI', 1, 29)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Breconshire', 'BRE', 1, 30)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Borders', 'BOR', 1, 31)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Berwickshire', 'BEW', 1, 32)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Berkshire', 'BRK', 1, 33)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Bedfordshire', 'BDF', 1, 34)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Bath', 'BAT', 1, 35)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Banffshire', 'BAN', 1, 36)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Ayrshire', 'AYR', 1, 37)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Argyllshire', 'ARL', 1, 38)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Angus', 'ANS', 1, 39)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Anglesey', 'AGY', 1, 40)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Alderney', 'ALD', 1, 41)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Aberdeenshire', 'ABD', 1, 42)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Limerick', 'LIM', 1, 43)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Londonderry', 'LDY', 1, 44)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Longford', 'LOG', 1, 45)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Louth', 'LOU', 1, 46)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Mayo', 'MAY', 1, 47)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Meath', 'MEA', 1, 48)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Monaghan', 'MOG', 1, 49)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Offaly', 'OFF', 1, 50)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Roscommon', 'ROS', 1, 51)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Sligo', 'SLI', 1, 52)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Tipperary', 'TIP', 1, 53)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Tyrone', 'TYR', 1, 54)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Waterford', 'WAT', 1, 55)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Westmeath', 'WEM', 1, 56)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Wexford', 'WEX', 1, 57)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Wicklow', 'WIC', 1, 58)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cornwall', 'CON', 1, 59)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cumberland', 'CUL', 1, 60)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cumbria', 'CMA', 1, 61)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Denbighshire', 'DEN', 1, 62)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Derbyshire', 'DBY', 1, 63)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Devon', 'DEV', 1, 64)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Dorset', 'DOR', 1, 65)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Dumfrie and Galloway', 'DGY', 1, 66)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Dumfriesshire', 'DFS', 1, 67)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Dunbartonshire', 'DNB', 1, 68)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Durham', 'DUR', 1, 69)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Dyfed', 'DFD', 1, 70)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'East Lothian', 'ELN', 1, 71)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'East Sussex', 'SXE', 1, 72)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Essex', 'ESS', 1, 73)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Fife', 'FIF', 1, 74)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Flintshire', 'FLN', 1, 75)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Glamorgan', 'GLA', 1, 76)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Gloucestershire', 'GLS', 1, 77)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Grampian', 'GMP', 1, 78)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Greater Manchester', 'GTM', 1, 79)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Guernsey', 'GSY', 1, 80)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Gwent', 'GWN', 1, 82)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Hampshire', 'HAM', 1, 83)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Herefordshire', 'HEF', 1, 84)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Hertfordshire', 'HRT', 1, 85)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Highland', 'HLD', 1, 86)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Humberside', 'HUM', 1, 87)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Huntingdonshire', 'HUN', 1, 88)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Inverness-shire', 'INV', 1, 89)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Isle Of Man', 'IOM', 1, 90)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Isle of Wight', 'IOW', 1, 91)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Jersey', 'JSY', 1, 92)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Kent', 'KEN', 1, 93)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Kincardineshire', 'KCD', 1, 94)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Kinross-shire', 'KRS', 1, 95)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Kirkcudbrightshire', 'KKD', 1, 96)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Lanarkshire', 'LKS', 1, 97)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Lancashire', 'LAN', 1, 98)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Leicestershire', 'LEI', 1, 99)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Lincolnshire', 'LIN', 1, 100)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'London', 'LND', 1, 101)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Lothian', 'LOT', 1, 102)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Merionethshire', 'MER', 1, 103)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Merseyside', 'MSY', 1, 104)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Mid Glamorgan', 'MGM', 1, 105)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Middlesex', 'MDX', 1, 106)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Midlothian', 'MLN', 1, 107)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Monmouthshire', 'MON', 1, 108)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Montgomeryshire', 'MGY', 1, 109)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Morayshire', 'MOR', 1, 110)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Nairn', 'NAI', 1, 111)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Norfolk', 'NFK', 1, 112)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'North Yorkshire', 'NYK', 1, 113)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Northamptonshire', 'NTH', 1, 114)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Northumberland', 'NBL', 1, 115)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Nottinghamshire', 'NTT', 1, 116)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Orkney', 'OKI', 1, 117)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Oxfordshire', 'OXF', 1, 118)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Peebles-shire', 'PEE', 1, 119)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Pembrokeshire', 'PEM', 1, 120)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Perthshire', 'PER', 1, 121)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Powys', 'POW', 1, 123)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Radnorshire', 'RAD', 1, 124)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Renfrewshire', 'RFW', 1, 125)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Ross and Cromarty', 'ROC', 1, 126)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Roxburghshire', 'ROX', 1, 127)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Rutland', 'RUT', 1, 128)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Sark', 'SRK', 1, 129)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Selkirkshire', 'SEL', 1, 130)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Shetland', 'SHI', 1, 131)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Shropshire', 'SAL', 1, 132)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Somerset', 'SOM', 1, 133)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'South Glamorgan', 'SGM', 1, 134)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'South Yorkshire', 'SYK', 1, 135)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Staffordshire', 'STS', 1, 136)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Stirlingshire', 'STI', 1, 137)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Strathclyde', 'STD', 1, 138)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Suffolk', 'SFK', 1, 139)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Surrey', 'SRY', 1, 140)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Sussex', 'SSX', 1, 141)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Sutherland', 'SUT', 1, 142)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Tayside', 'TAY', 1, 143)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Tyne and Wear', 'TWR', 1, 144)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Warwickshire', 'WAR', 1, 145)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'West Glamorgan', 'WGM', 1, 146)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'West Lothian', 'WLN', 1, 147)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'West Midlands', 'WMD', 1, 148)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'West Sussex', 'SXW', 1, 149)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'West Yorkshire', 'WYK', 1, 150)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Western Isles', 'WIS', 1, 151)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Westmorland', 'WES', 1, 152)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Wigtownshire', 'WIG', 1, 153)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Worcestershire', 'WOR', 1, 154)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Yorkshire', 'YKS', 1, 155)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Yorkshire East Riding', 'ERY', 1, 156)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Yorkshire North Riding', 'NRY', 1, 157)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Yorkshire West Riding', 'WRY', 1, 158)

exceed

Total Posts: 7
Karma: 35
Joined: 1/26/2012
Location: United Kingdom

Posted: 10 years ago

Just to let you know, using this on my site (that is just being set up!).

Wanted to say thank you.

Project.Italy

Total Posts: 18
Karma: 628
Joined: 6/23/2011
Location: Italy

Posted: 10 years ago

Really useful to me too.

Thanks

justinclarke

Total Posts: 4
Karma: 70
Joined: 11/6/2013
Location: United Kingdom

Posted: 9 years ago

Excellent post thanks.

I wanted them in alphabetical order so I modified yours. I set the display order to the same for all and then changed a small bit of code inside Libraries > Nop.Services\Directory\StateProvinceService.cs > GetStateProvincesByCountryId()...

Instead of...

public virtual IList<StateProvince> GetStateProvincesByCountryId(int countryId, bool showHidden = false)
        {
            string key = string.Format(STATEPROVINCES_ALL_KEY, countryId);
            return _cacheManager.Get(key, () =>
            {
                var query = from sp in _stateProvinceRepository.Table
                            orderby sp.DisplayOrder
                            where sp.CountryId == countryId &&
                            (showHidden || sp.Published)
                            select sp;
                var stateProvinces = query.ToList();
                return stateProvinces;
            });
        }

I did...

public virtual IList<StateProvince> GetStateProvincesByCountryId(int countryId, bool showHidden = false)
        {
            string key = string.Format(STATEPROVINCES_ALL_KEY, countryId);
            return _cacheManager.Get(key, () =>
            {
                var query = from sp in _stateProvinceRepository.Table
                            orderby sp.DisplayOrder, sp.Name
                            where sp.CountryId == countryId &&
                            (showHidden || sp.Published)
                            select sp;
                var stateProvinces = query.ToList();
                return stateProvinces;
            });
        }

Here is the new script:

DECLARE @CountryId INT;

SELECT @CountryId = [Id] FROM [Country] WHERE [TwoLetterIsoCode] = 'GB'

INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder])
VALUES
(@CountryId, 'Co. Leitrim', 'LET', 1, 100)
,(@CountryId, 'Co. Laois', 'LEX', 1, 100)
,(@CountryId, 'Co. Kilkenny', 'KIK', 1, 100)
,(@CountryId, 'Co. Kildare', 'KID', 1, 100)
,(@CountryId, 'Co. Kerry', 'KER', 1, 100)
,(@CountryId, 'Co. Galway', 'GAL', 1, 100)
,(@CountryId, 'Co. Fermanagh', 'FER', 1, 100)
,(@CountryId, 'Co. Dublin', 'DUB', 1, 100)
,(@CountryId, 'Co. Down', 'DOW', 1, 100)
,(@CountryId, 'Co. Donegal', 'DON', 1, 100)
,(@CountryId, 'Co. Cork', 'COR', 1, 100)
,(@CountryId, 'Co. Clare', 'CLA', 1, 100)
,(@CountryId, 'Co. Cavan', 'CAV', 1, 100)
,(@CountryId, 'Co. Carlow', 'CAR', 1, 100)
,(@CountryId, 'Co. Armagh', 'ARM', 1, 100)
,(@CountryId, 'Co. Antrim', 'ANT', 1, 100)
,(@CountryId, 'Clwyd', 'CWD', 1, 100)
,(@CountryId, 'Cleveland', 'CLV', 1, 100)
,(@CountryId, 'Clackmannanshire', 'CLK', 1, 100)
,(@CountryId, 'Cheshire', 'CHS', 1, 100)
,(@CountryId, 'Central', 'CEN', 1, 100)
,(@CountryId, 'Carmarthenshir', 'CMN', 1, 100)
,(@CountryId, 'Cardiganshire', 'CGN', 1, 100)
,(@CountryId, 'Cambridgeshire', 'CAM', 1, 100)
,(@CountryId, 'Caithness', 'CAI', 1, 100)
,(@CountryId, 'Caernarvonshire', 'CAE', 1, 100)
,(@CountryId, 'Bute', 'BUT', 1, 100)
,(@CountryId, 'Buckinghamshire', 'BKM', 1, 100)
,(@CountryId, 'Bristol', 'BRI', 1, 100)
,(@CountryId, 'Breconshire', 'BRE', 1, 100)
,(@CountryId, 'Borders', 'BOR', 1, 100)
,(@CountryId, 'Berwickshire', 'BEW', 1, 100)
,(@CountryId, 'Berkshire', 'BRK', 1, 100)
,(@CountryId, 'Bedfordshire', 'BDF', 1, 100)
,(@CountryId, 'Bath', 'BAT', 1, 100)
,(@CountryId, 'Banffshire', 'BAN', 1, 100)
,(@CountryId, 'Ayrshire', 'AYR', 1, 100)
,(@CountryId, 'Argyllshire', 'ARL', 1, 100)
,(@CountryId, 'Angus', 'ANS', 1, 100)
,(@CountryId, 'Anglesey', 'AGY', 1, 100)
,(@CountryId, 'Alderney', 'ALD', 1, 100)
,(@CountryId, 'Aberdeenshire', 'ABD', 1, 100)
,(@CountryId, 'Co. Limerick', 'LIM', 1, 100)
,(@CountryId, 'Co. Londonderry', 'LDY', 1, 100)
,(@CountryId, 'Co. Longford', 'LOG', 1, 100)
,(@CountryId, 'Co. Louth', 'LOU', 1, 100)
,(@CountryId, 'Co. Mayo', 'MAY', 1, 100)
,(@CountryId, 'Co. Meath', 'MEA', 1, 100)
,(@CountryId, 'Co. Monaghan', 'MOG', 1, 100)
,(@CountryId, 'Co. Offaly', 'OFF', 1, 100)
,(@CountryId, 'Co. Roscommon', 'ROS', 1, 100)
,(@CountryId, 'Co. Sligo', 'SLI', 1, 100)
,(@CountryId, 'Co. Tipperary', 'TIP', 1, 100)
,(@CountryId, 'Co. Tyrone', 'TYR', 1, 100)
,(@CountryId, 'Co. Waterford', 'WAT', 1, 100)
,(@CountryId, 'Co. Westmeath', 'WEM', 1, 100)
,(@CountryId, 'Co. Wexford', 'WEX', 1, 100)
,(@CountryId, 'Co. Wicklow', 'WIC', 1, 100)
,(@CountryId, 'Cornwall', 'CON', 1, 100)
,(@CountryId, 'Cumberland', 'CUL', 1, 100)
,(@CountryId, 'Cumbria', 'CMA', 1, 100)
,(@CountryId, 'Denbighshire', 'DEN', 1, 100)
,(@CountryId, 'Derbyshire', 'DBY', 1, 100)
,(@CountryId, 'Devon', 'DEV', 1, 100)
,(@CountryId, 'Dorset', 'DOR', 1, 100)
,(@CountryId, 'Dumfrie and Galloway', 'DGY', 1, 100)
,(@CountryId, 'Dumfriesshire', 'DFS', 1, 100)
,(@CountryId, 'Dunbartonshire', 'DNB', 1, 100)
,(@CountryId, 'Durham', 'DUR', 1, 100)
,(@CountryId, 'Dyfed', 'DFD', 1, 100)
,(@CountryId, 'East Lothian', 'ELN', 1, 100)
,(@CountryId, 'East Sussex', 'SXE', 1, 100)
,(@CountryId, 'Essex', 'ESS', 1, 100)
,(@CountryId, 'Fife', 'FIF', 1, 100)
,(@CountryId, 'Flintshire', 'FLN', 1, 100)
,(@CountryId, 'Glamorgan', 'GLA', 1, 100)
,(@CountryId, 'Gloucestershire', 'GLS', 1, 100)
,(@CountryId, 'Grampian', 'GMP', 1, 100)
,(@CountryId, 'Greater Manchester', 'GTM', 1, 100)
,(@CountryId, 'Guernsey', 'GSY', 1, 100)
,(@CountryId, 'Gwent', 'GWN', 1, 100)
,(@CountryId, 'Hampshire', 'HAM', 1, 100)
,(@CountryId, 'Herefordshire', 'HEF', 1, 100)
,(@CountryId, 'Hertfordshire', 'HRT', 1, 100)
,(@CountryId, 'Highland', 'HLD', 1, 100)
,(@CountryId, 'Humberside', 'HUM', 1, 100)
,(@CountryId, 'Huntingdonshire', 'HUN', 1, 100)
,(@CountryId, 'Inverness-shire', 'INV', 1, 100)
,(@CountryId, 'Isle Of Man', 'IOM', 1, 100)
,(@CountryId, 'Isle of Wight', 'IOW', 1, 100)
,(@CountryId, 'Jersey', 'JSY', 1, 100)
,(@CountryId, 'Kent', 'KEN', 1, 100)
,(@CountryId, 'Kincardineshire', 'KCD', 1, 100)
,(@CountryId, 'Kinross-shire', 'KRS', 1, 100)
,(@CountryId, 'Kirkcudbrightshire', 'KKD', 1, 100)
,(@CountryId, 'Lanarkshire', 'LKS', 1, 100)
,(@CountryId, 'Lancashire', 'LAN', 1, 100)
,(@CountryId, 'Leicestershire', 'LEI', 1, 100)
,(@CountryId, 'Lincolnshire', 'LIN', 1, 100)
,(@CountryId, 'London', 'LND', 1, 100)
,(@CountryId, 'Lothian', 'LOT', 1, 100)
,(@CountryId, 'Merionethshire', 'MER', 1, 100)
,(@CountryId, 'Merseyside', 'MSY', 1, 100)
,(@CountryId, 'Mid Glamorgan', 'MGM', 1, 100)
,(@CountryId, 'Middlesex', 'MDX', 1, 100)
,(@CountryId, 'Midlothian', 'MLN', 1, 100)
,(@CountryId, 'Monmouthshire', 'MON', 1, 100)
,(@CountryId, 'Montgomeryshire', 'MGY', 1, 100)
,(@CountryId, 'Morayshire', 'MOR', 1, 100)
,(@CountryId, 'Nairn', 'NAI', 1, 100)
,(@CountryId, 'Norfolk', 'NFK', 1, 100)
,(@CountryId, 'North Yorkshire', 'NYK', 1, 100)
,(@CountryId, 'Northamptonshire', 'NTH', 1, 100)
,(@CountryId, 'Northumberland', 'NBL', 1, 100)
,(@CountryId, 'Nottinghamshire', 'NTT', 1, 100)
,(@CountryId, 'Orkney', 'OKI', 1, 100)
,(@CountryId, 'Oxfordshire', 'OXF', 1, 100)
,(@CountryId, 'Peebles-shire', 'PEE', 1, 100)
,(@CountryId, 'Pembrokeshire', 'PEM', 1, 100)
,(@CountryId, 'Perthshire', 'PER', 1, 100)
,(@CountryId, 'Powys', 'POW', 1, 100)
,(@CountryId, 'Radnorshire', 'RAD', 1, 100)
,(@CountryId, 'Renfrewshire', 'RFW', 1, 100)
,(@CountryId, 'Ross and Cromarty', 'ROC', 1, 100)
,(@CountryId, 'Roxburghshire', 'ROX', 1, 100)
,(@CountryId, 'Rutland', 'RUT', 1, 100)
,(@CountryId, 'Sark', 'SRK', 1, 100)
,(@CountryId, 'Selkirkshire', 'SEL', 1, 100)
,(@CountryId, 'Shetland', 'SHI', 1, 100)
,(@CountryId, 'Shropshire', 'SAL', 1, 100)
,(@CountryId, 'Somerset', 'SOM', 1, 100)
,(@CountryId, 'South Glamorgan', 'SGM', 1, 100)
,(@CountryId, 'South Yorkshire', 'SYK', 1, 100)
,(@CountryId, 'Staffordshire', 'STS', 1, 100)
,(@CountryId, 'Stirlingshire', 'STI', 1, 100)
,(@CountryId, 'Strathclyde', 'STD', 1, 100)
,(@CountryId, 'Suffolk', 'SFK', 1, 100)
,(@CountryId, 'Surrey', 'SRY', 1, 100)
,(@CountryId, 'Sussex', 'SSX', 1, 100)
,(@CountryId, 'Sutherland', 'SUT', 1, 100)
,(@CountryId, 'Tayside', 'TAY', 1, 100)
,(@CountryId, 'Tyne and Wear', 'TWR', 1, 100)
,(@CountryId, 'Warwickshire', 'WAR', 1, 100)
,(@CountryId, 'West Glamorgan', 'WGM', 1, 100)
,(@CountryId, 'West Lothian', 'WLN', 1, 100)
,(@CountryId, 'West Midlands', 'WMD', 1, 100)
,(@CountryId, 'West Sussex', 'SXW', 1, 100)
,(@CountryId, 'West Yorkshire', 'WYK', 1, 100)
,(@CountryId, 'Western Isles', 'WIS', 1, 100)
,(@CountryId, 'Westmorland', 'WES', 1, 100)
,(@CountryId, 'Wigtownshire', 'WIG', 1, 100)
,(@CountryId, 'Worcestershire', 'WOR', 1, 100)
,(@CountryId, 'Yorkshire', 'YKS', 1, 100)
,(@CountryId, 'Yorkshire East Riding', 'ERY', 1, 100)
,(@CountryId, 'Yorkshire North Riding', 'NRY', 1, 100)
,(@CountryId, 'Yorkshire West Riding', 'WRY', 1, 100)

Tredegar

Total Posts: 39
Karma: 255
Joined: 6/30/2014
Location: United Kingdom

Posted: 9 years ago

Thanks you all, great stuff :o)

LewisHamill

Total Posts: 8
Karma: 70
Joined: 8/16/2016
Location: United Kingdom

Posted: 7 years ago

I reordered the list alphabetically:


DECLARE @CountryId INT;

SELECT @CountryId = [Id] FROM [Country] WHERE [TwoLetterIsoCode] = 'GB'


INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Aberdeenshire', 'ABD', 1, 1)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Alderney', 'ALD', 1, 2)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Anglesey', 'AGY', 1, 3)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Angus', 'ANS', 1, 4)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Argyllshire', 'ARL', 1, 5)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Ayrshire', 'AYR', 1, 6)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Banffshire', 'BAN', 1, 7)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Bath', 'BAT', 1, 8)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Bedfordshire', 'BDF', 1, 9)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Berkshire', 'BRK', 1, 10)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Berwickshire', 'BEW', 1, 11)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Borders', 'BOR', 1, 12)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Breconshire', 'BRE', 1, 13)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Bristol', 'BRI', 1, 14)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Buckinghamshire', 'BKM', 1, 15)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Bute', 'BUT', 1, 16)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Caernarvonshire', 'CAE', 1, 17)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Caithness', 'CAI', 1, 18)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cambridgeshire', 'CAM', 1, 19)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cardiganshire', 'CGN', 1, 20)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Carmarthenshir', 'CMN', 1, 21)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Central', 'CEN', 1, 22)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cheshire', 'CHS', 1, 23)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Clackmannanshire', 'CLK', 1, 24)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cleveland', 'CLV', 1, 25)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Clwyd', 'CWD', 1, 26)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Antrim', 'ANT', 1, 27)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Armagh', 'ARM', 1, 28)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Carlow', 'CAR', 1, 29)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Cavan', 'CAV', 1, 30)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Clare', 'CLA', 1, 31)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Cork', 'COR', 1, 32)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Donegal', 'DON', 1, 33)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Down', 'DOW', 1, 34)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Dublin', 'DUB', 1, 35)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Fermanagh', 'FER', 1, 36)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Galway', 'GAL', 1, 37)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Kerry', 'KER', 1, 38)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Kildare', 'KID', 1, 39)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Kilkenny', 'KIK', 1, 40)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Laois', 'LEX', 1, 41)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Leitrim', 'LET', 1, 42)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Limerick', 'LIM', 1, 43)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Londonderry', 'LDY', 1, 44)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Longford', 'LOG', 1, 45)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Louth', 'LOU', 1, 46)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Mayo', 'MAY', 1, 47)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Meath', 'MEA', 1, 48)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Monaghan', 'MOG', 1, 49)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Offaly', 'OFF', 1, 50)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Roscommon', 'ROS', 1, 51)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Sligo', 'SLI', 1, 52)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Tipperary', 'TIP', 1, 53)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Tyrone', 'TYR', 1, 54)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Waterford', 'WAT', 1, 55)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Westmeath', 'WEM', 1, 56)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Wexford', 'WEX', 1, 57)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Co. Wicklow', 'WIC', 1, 58)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cornwall', 'CON', 1, 59)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cumberland', 'CUL', 1, 60)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Cumbria', 'CMA', 1, 61)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Denbighshire', 'DEN', 1, 62)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Derbyshire', 'DBY', 1, 63)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Devon', 'DEV', 1, 64)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Dorset', 'DOR', 1, 65)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Dumfrie and Galloway', 'DGY', 1, 66)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Dumfriesshire', 'DFS', 1, 67)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Dunbartonshire', 'DNB', 1, 68)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Durham', 'DUR', 1, 69)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Dyfed', 'DFD', 1, 70)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'East Lothian', 'ELN', 1, 71)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'East Sussex', 'SXE', 1, 72)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Essex', 'ESS', 1, 73)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Fife', 'FIF', 1, 74)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Flintshire', 'FLN', 1, 75)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Glamorgan', 'GLA', 1, 76)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Gloucestershire', 'GLS', 1, 77)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Grampian', 'GMP', 1, 78)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Greater Manchester', 'GTM', 1, 79)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Guernsey', 'GSY', 1, 80)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Gwent', 'GWN', 1, 82)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Hampshire', 'HAM', 1, 83)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Herefordshire', 'HEF', 1, 84)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Hertfordshire', 'HRT', 1, 85)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Highland', 'HLD', 1, 86)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Humberside', 'HUM', 1, 87)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Huntingdonshire', 'HUN', 1, 88)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Inverness-shire', 'INV', 1, 89)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Isle Of Man', 'IOM', 1, 90)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Isle of Wight', 'IOW', 1, 91)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Jersey', 'JSY', 1, 92)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Kent', 'KEN', 1, 93)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Kincardineshire', 'KCD', 1, 94)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Kinross-shire', 'KRS', 1, 95)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Kirkcudbrightshire', 'KKD', 1, 96)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Lanarkshire', 'LKS', 1, 97)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Lancashire', 'LAN', 1, 98)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Leicestershire', 'LEI', 1, 99)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Lincolnshire', 'LIN', 1, 100)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'London', 'LND', 1, 101)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Lothian', 'LOT', 1, 102)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Merionethshire', 'MER', 1, 103)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Merseyside', 'MSY', 1, 104)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Mid Glamorgan', 'MGM', 1, 105)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Middlesex', 'MDX', 1, 106)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Midlothian', 'MLN', 1, 107)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Monmouthshire', 'MON', 1, 108)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Montgomeryshire', 'MGY', 1, 109)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Morayshire', 'MOR', 1, 110)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Nairn', 'NAI', 1, 111)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Norfolk', 'NFK', 1, 112)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'North Yorkshire', 'NYK', 1, 113)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Northamptonshire', 'NTH', 1, 114)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Northumberland', 'NBL', 1, 115)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Nottinghamshire', 'NTT', 1, 116)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Orkney', 'OKI', 1, 117)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Oxfordshire', 'OXF', 1, 118)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Peebles-shire', 'PEE', 1, 119)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Pembrokeshire', 'PEM', 1, 120)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Perthshire', 'PER', 1, 121)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Powys', 'POW', 1, 123)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Radnorshire', 'RAD', 1, 124)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Renfrewshire', 'RFW', 1, 125)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Ross and Cromarty', 'ROC', 1, 126)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Roxburghshire', 'ROX', 1, 127)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Rutland', 'RUT', 1, 128)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Sark', 'SRK', 1, 129)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Selkirkshire', 'SEL', 1, 130)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Shetland', 'SHI', 1, 131)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Shropshire', 'SAL', 1, 132)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Somerset', 'SOM', 1, 133)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'South Glamorgan', 'SGM', 1, 134)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'South Yorkshire', 'SYK', 1, 135)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Staffordshire', 'STS', 1, 136)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Stirlingshire', 'STI', 1, 137)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Strathclyde', 'STD', 1, 138)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Suffolk', 'SFK', 1, 139)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Surrey', 'SRY', 1, 140)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Sussex', 'SSX', 1, 141)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Sutherland', 'SUT', 1, 142)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Tayside', 'TAY', 1, 143)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Tyne and Wear', 'TWR', 1, 144)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Warwickshire', 'WAR', 1, 145)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'West Glamorgan', 'WGM', 1, 146)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'West Lothian', 'WLN', 1, 147)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'West Midlands', 'WMD', 1, 148)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'West Sussex', 'SXW', 1, 149)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'West Yorkshire', 'WYK', 1, 150)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Western Isles', 'WIS', 1, 151)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Westmorland', 'WES', 1, 152)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Wigtownshire', 'WIG', 1, 153)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Worcestershire', 'WOR', 1, 154)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Yorkshire', 'YKS', 1, 155)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Yorkshire East Riding', 'ERY', 1, 156)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Yorkshire North Riding', 'NRY', 1, 157)
INSERT INTO [StateProvince] ([CountryId], [Name], [Abbreviation], [Published], [DisplayOrder]) VALUES (@CountryId, 'Yorkshire West Riding', 'WRY', 1, 158)

petemitch

MVP

Certified Developer

Total Posts: 558
Karma: 6401
Joined: 7/29/2011
Location: United Kingdom

Posted: 7 years ago

Has anyone told the Irish that Dublin (and the rest of Ireland) is now in Great Britain? I don't think they're going to be happy :-)

That list looks like some kind of bizarre mashup of old county names, postal districts, unitary authorities and Irish counties (this Wikipedia article has good summary of the complicated history of UK county name changes). The requirement to put the county name in UK addresses was phased out by Royal Mail some time ago, but if you want a better list then the one that's included in the official nopCommerce states and provinces download is much better than the list above. Details in this post: https://www.nopcommerce.com/boards/t/30664/massive-import-of-stateprovinces-of-countries-help-us-with-your-countrys-data.aspx?p=3#135882

These are also supplied in a format that can be imported from the admin interface without having to run SQL on the database.

2013 UK Counties insert

Still have questions or need help?