Queries/17 mcpfe-2011 UPDATE COUNTRY_NAME.sql at master · apkretov/Queries · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
USE Timber
GO
BEGIN TRANSACTION

SELECT DISTINCT [mcpfe-2011].COUNTRY_NAME, Countries.COUNTRY_NAME
FROM [mcpfe-2011]
LEFT OUTER JOIN Countries ON [mcpfe-2011].COUNTRY_NAME = Countries.COUNTRY_NAME
WHERE (STATE_STRUCTURE_NAME = N'A4.6a'
		OR STATE_STRUCTURE_NAME = N'A6.7'
		OR STATE_STRUCTURE_NAME LIKE N'A6.8%'
	)
	AND Countries.COUNTRY_NAME IS NULL

UPDATE [mcpfe-2011]
SET COUNTRY_NAME = N'Moldova, Republic of'
WHERE (STATE_STRUCTURE_NAME = N'A4.6a'
		OR STATE_STRUCTURE_NAME = N'A6.7'
		OR STATE_STRUCTURE_NAME LIKE N'A6.8%'
	)
	AND COUNTRY_NAME = N'Republic of Moldova'

UPDATE [mcpfe-2011]
SET COUNTRY_NAME = N'Slovakia'
WHERE (STATE_STRUCTURE_NAME = N'A4.6a'
		OR STATE_STRUCTURE_NAME = N'A6.7'
		OR STATE_STRUCTURE_NAME LIKE N'A6.8%'
	)
	AND COUNTRY_NAME = N'Slovak Republic'

UPDATE [mcpfe-2011]
SET COUNTRY_NAME = N'The former Yugoslav Republic of Macedonia'
WHERE (STATE_STRUCTURE_NAME = N'A4.6a'
		OR STATE_STRUCTURE_NAME = N'A6.7'
		OR STATE_STRUCTURE_NAME LIKE N'A6.8%'
	)
	AND COUNTRY_NAME = N'The fYR of Macedonia'

SELECT DISTINCT [mcpfe-2011].COUNTRY_NAME, Countries.COUNTRY_NAME
FROM [mcpfe-2011]
LEFT OUTER JOIN Countries ON [mcpfe-2011].COUNTRY_NAME = Countries.COUNTRY_NAME
WHERE (STATE_STRUCTURE_NAME = N'A4.6a'
		OR STATE_STRUCTURE_NAME = N'A6.7'
		OR STATE_STRUCTURE_NAME LIKE N'A6.8%'
	)
	AND Countries.COUNTRY_NAME IS NULL

ROLLBACK TRANSACTION
--COMMIT TRANSACTION
GO