Breaking News: Grepper is joining You.com. Read the official announcement!

VSMoebel_MS..countryIndicators

Marco Paus answered on March 13, 2023 Popularity 1/10 Helpfulness 1/10

answer VSMoebel_MS..countryIndicators

VSMoebel_MS..countryIndicators

Comment

VSMoebel_RO..countryIndicators --View in RO nicht MS

Leider wurde eine Stell im Skript zu viel angepasst:

set @ExistsAttributes = (Select count(distinct dbo.fn_SLCleanChars(AttributeBezg, 'A-Z,0-9,_'))  from SLAttribute_Typ a left join SLAttribute b
	on a.AttributeID = b.AttributeID
	where a.TypID = @iTypID and dbo.fn_SLCleanChars(AttributeBezg, 'A-Z,0-9,_') in 
('HDI_ACTUAL','CPI_ACTUAL'))
print @itypid
if (@itypid !=-1 AND @ExistCountryIndicators > 0 AND @ExistsAttributes > 0)
begin
    DELETE FROM SLLand_Merkmal WHERE Merkmal in ('HDI_ACTUAL','CPI_ACTUAL')
    INSERT INTO SLLand_Merkmal (land,Merkmal, Wert)
    Select latest.CountryIdentifier, latest.Merkmal, replace(Wert,',','.') from  VSMoebel_MS..countryIndicators base inner  join
    (Select Merkmal, CountryIdentifier, MAX(Datum) as maxdatum from  
    VSMoebel_MS..countryIndicators where Merkmal IN ('HDI_ACTUAL','CPI_ACTUAL') group by  CountryIdentifier, Merkmal) latest
		on base.Merkmal = latest.Merkmal and base.CountryIdentifier = 
    latest.CountryIdentifier and base.Datum = latest.maxdatum
end

Bei der Abfrage auf die Attributes ist es richtig, dass er auf HDI_ACTUAL und CPI_ACTUAL prüft, da das Merkmal so im WebCIS angelegt wird.

In dem View countryIndicators stehen die Merkmale allerdings mit HDI und CPI.
Hier müsste der select also entsprechend auf HDI und CPI gehen.

Bitte um Anpassung.

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: bugzilla.cis.softconcis.de

Tags: whatever

Link to this answer
Share Copy Link

Contributed on Mar 13 2023

Marco Paus

0 Answers Avg Quality 2/10

VSMoebel_MS..countryIndicators

Contents

More Related Answers

VSMoebel_MS..countryIndicators

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.