Hi there.
Again many thanks for your help.
I tried below:
update TaxRateTransp set Percentage=21 where Id=6 and CountryId=72 and StateProvinceId=83 and Percentage=0;
But no luck.
In case it's relevant content of the 3 tables containing 'tax' word:
TaxRate
Id TaxCategoryId CountryId StateProvinceId Zip Percentage StoreId
3 6 72 0 4 0
6 8 72 0 8 0
7 7 72 0 18 0
8 3 72 0 16 0
9 10 72 0 21 0
10 11 72 0 10 0
13 12 72 0 7 0
TaxCategory
Id Name DisplayOrder
2 Reducido 5
3 Ordinario 10
6 Super Reducido 0
7 Ordinario 18 15
8 Reducido 8 7
10 Ordinario 21 % 2
11 Reducido 10 0
12 Reducido 7 20
TaxRateTransp
Id CountryId StateProvinceId Percentage
1 72 77 4
2 72 78 3
3 72 79 6
4 72 80 4
5 72 81 6
6 72 83 0
7 72 76 3
8 72 84 3
9 72 85 6
10 72 86 6
11 72 87 2
12 72 88 5
13 72 89 5
14 72 90 5
15 72 91 5
16 72 92 1
17 72 93 5
18 72 94 5
19 72 96 6
20 72 97 4
21 72 98 5
22 72 99 4
23 72 100 1
24 72 101 3
25 72 102 5
26 72 103 3
27 72 104 5
28 72 106 4
29 72 108 5
30 72 109 4
31 72 110 5
32 72 111 7
33 72 112 5
34 72 113 5
35 72 116 4
StateProvince
Id CountryId Name Abbreviation Published DisplayOrder
1 1 AA (Armed Forces Americas) AA True 1
2 1 AE (Armed Forces Europe) AE True 1
3 1 Alabama AL True 1
4 1 Alaska AK True 1
5 1 American Samoa AS True 1
6 1 AP (Armed Forces Pacific) AP True 1
7 1 Arizona AZ True 1
8 1 Arkansas AR True 1
9 1 California CA True 1
10 1 Colorado CO True 1
11 1 Connecticut CT True 1
12 1 Delaware DE True 1
13 1 District of Columbia DC True 1
14 1 Federated States of Micronesia FM True 1
15 1 Florida FL True 1
16 1 Georgia GA True 1
17 1 Guam GU True 1
18 1 Hawaii HI True 1
19 1 Idaho ID True 1
20 1 Illinois IL True 1
21 1 Indiana IN True 1
22 1 Iowa IA True 1
23 1 Kansas KS True 1
24 1 Kentucky KY True 1
25 1 Louisiana LA True 1
26 1 Maine ME True 1
27 1 Marshall Islands MH True 1
28 1 Maryland MD True 1
29 1 Massachusetts MA True 1
30 1 Michigan MI True 1
31 1 Minnesota MN True 1
32 1 Mississippi MS True 1
33 1 Missouri MO True 1
34 1 Montana MT True 1
35 1 Nebraska NE True 1
36 1 Nevada NV True 1
37 1 New Hampshire NH True 1
38 1 New Jersey NJ True 1
39 1 New Mexico NM True 1
40 1 New York NY True 1
41 1 North Carolina NC True 1
42 1 North Dakota ND True 1
43 1 Northern Mariana Islands MP True 1
44 1 Ohio OH True 1
45 1 Oklahoma OK True 1
46 1 Oregon OR True 1
47 1 Palau PW True 1
48 1 Pennsylvania PA True 1
49 1 Puerto Rico PR True 1
50 1 Rhode Island RI True 1
51 1 South Carolina SC True 1
52 1 South Dakota SD True 1
53 1 Tennessee TN True 1
54 1 Texas TX True 1
55 1 Utah UT True 1
56 1 Vermont VT True 1
57 1 Virgin Islands VI True 1
58 1 Virginia VA True 1
59 1 Washington WA True 1
60 1 West Virginia WV True 1
61 1 Wisconsin WI True 1
62 1 Wyoming WY True 1
63 2 Alberta AB True 1
64 2 British Columbia BC True 1
65 2 Manitoba MB True 1
66 2 New Brunswick NB True 1
67 2 Newfoundland and Labrador NL True 1
68 2 Northwest Territories NT True 1
69 2 Nova Scotia NS True 1
70 2 Nunavut NU True 1
71 2 Ontario ON True 1
72 2 Prince Edward Island PE True 1
73 2 Quebec QC True 1
74 2 Saskatchewan SK True 1
75 2 Yukon Territory YU True 1
76 72 Alava 01 True 1
77 72 Albacete 02 True 1
78 72 Alicante 03 True 1
79 72 Almeria 04 True 1
80 72 Avila 05 True 1
81 72 Badajoz 06 True 1
82 72 Baleares 07 True 1
83 72 Barcelona 08 True 1
84 72 Burgos 09 True 1
85 72 Caceres 10 True 1
86 72 Cadiz 11 True 1
87 72 Castellon 12 True 1
88 72 Ciudad Real 13 True 1
89 72 Cordoba 14 True 1
90 72 A Coruña 15 True 1
91 72 Cuenca 16 True 1
92 72 Girona 17 True 1
93 72 Granada 18 True 1
94 72 Guadalajara 19 True 1
95 72 Guipuzcoa 20 True 1
96 72 Huelva 21 True 1
97 72 Huesca 22 True 1
98 72 Jaen 23 True 1
99 72 Leon 24 True 1
100 72 Lleida 25 True 1
101 72 La Rioja 26 True 1
102 72 Lugo 27 True 1
103 72 Madrid 28 True 1
104 72 Malaga 29 True 1
106 72 Murcia 30 True 1
107 72 Navarra 31 True 1
108 72 Orense 32 True 1
109 72 Asturias 33 True 1
110 72 Palencia 34 True 1
111 72 LasPalmas 35 True 1
112 72 Pontevedra 36 True 1
113 72 Salamanca 37 True 1
114 72 Santa Cruz de Tenerife 38 True 1
115 72 Cantabria 39 True 1
116 72 Segovia 40 True 1
117 72 Sevilla 41 True 1
118 72 Soria 42 True 1
119 72 Tarragona 43 True 1
120 72 Teruel 44 True 1
121 72 Toledo 45 True 1
122 72 Valencia 46 True 1
123 72 Valladolid 47 True 1
124 72 Vizcaya 48 True 1
125 72 Zamora 49 True 1
126 72 Zaragoza 50 True 1
127 72 Ceuta 51 True 1
128 72 Melilla 52 True 1
Any ideas will be appreciated.
Thanks.