Just to understand:

Do you need all these language-dependent columns in the same query, or do you later filter only those you need for the current connection/current language, what ever? (I'm asking since it is a common requirement to return a description in the "one and only appropriate language" for the current client but that seems not to be the case here...)

And do you require two columns for "DK" and only one for the other languages?

The languages which is typed in all this subselects is all Possible languages that can be used. Used languages codes is in tables tblLang. This can I type with select distinct lang_lang from tblLang. This will return all used language codes like IT, DKK etc.. Wich would be the best. Instead of use many subselects I hope I can use it in a smarter way. DKK is on row 1,3 and 4. All other languages is on row 1 and 3.

DROP TABLE IF EXISTS tbllangdesc;

    CREATE TABLE tbllangdesc
        (
        ID integer,
        langcode nvarchar(3),
        f_desc nvarchar(40),
        rownr smallint
        );

        INSERT INTO tbllangdesc VALUES (1,'EN', 'Test row 1 EN', 1);
        INSERT INTO tbllangdesc VALUES (1,'EN', 'Test row 3 EN', 3);
        INSERT INTO tbllangdesc VALUES (1,'IT', 'Test row 1 IT', 1);
        INSERT INTO tbllangdesc VALUES (1,'IT', 'Test row 3 IT', 3);
        INSERT INTO tbllangdesc VALUES (1,'DKK', 'Test row 1 DKK', 1);
        INSERT INTO tbllangdesc VALUES (1,'DKK', 'Test row 3 DKK', 3);
        INSERT INTO tbllangdesc VALUES (1,'DKK', 'Test row 4 DKK', 4);
        INSERT INTO tbllangdesc VALUES (1,'RU', 'Test row 1 RU', 1);
        INSERT INTO tbllangdesc VALUES (1,'RU', 'Test row 3 RU', 3);
        INSERT INTO tbllangdesc VALUES (2,'EN', 'Test row 1 EN', 1);
        INSERT INTO tbllangdesc VALUES (2,'EN', 'Test row 3 EN', 3);
        INSERT INTO tbllangdesc VALUES (2,'IT', 'Test row 1 IT', 1);
        INSERT INTO tbllangdesc VALUES (2,'IT', 'Test row 3 IT', 3);
        INSERT INTO tbllangdesc VALUES (2,'DKK', 'Test row 1 DKK', 1);
        INSERT INTO tbllangdesc VALUES (2,'DKK', 'Test row 3 DKK', 3);
        INSERT INTO tbllangdesc VALUES (2,'DKK', 'Test row 4 DKK', 4);
        INSERT INTO tbllangdesc VALUES (2,'RU', 'Test row 1 RU', 1);
        INSERT INTO tbllangdesc VALUES (2,'RU', 'Test row 3 RU', 3);
        INSERT INTO tbllangdesc VALUES (2,'PL', 'Test row 1 PL', 1);
        INSERT INTO tbllangdesc VALUES (2,'PL', 'Test row 3 PL', 3);

        select ....... from tbllangdesc  //should return this (even column names)

        ID---LangDescEN1----LangDescEN3----LangDescIT1----LangDescIT3----LangDescDKK1----LangDescDKK3----LangDescDKK4----LangDescRU1----LangDescRU3----LangDescPL1----LangDescPL3
        --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
        1---Test row 1 EN---Test row 3 EN--Test row 1 IT--Test row 3 IT--Test row 1 DKK--Test row 3 DKK--Test row 4 DKK--Test row 1 RU--Test row 3 RU--NULL()---------NULL()------
        2---Test row 1 EN---Test row 3 EN--Test row 1 IT--Test row 3 IT--Test row 1 DKK--Test row 3 DKK--Test row 4 DKK--Test row 1 RU--Test row 3 RU--Test row 1 PL--Test row 3 PL

Should be doing in a different way (smarter way with smaller code) than subselect I done now