Master GetItem

CREATE PROCEDURE [dbo].[fm_clientQuestionaries_getItem]
    @itemID int,
    @username nvarchar(256),
    @parameters ExtendedDictionaryParameter READONLY
AS
BEGIN
declare @langID int
    select @langID = try_cast(Value as int) from @parameters where [Key] = 'langID'



    declare @userGuid uniqueidentifier
    select @userGuid = try_cast(Value as uniqueidentifier) from @parameters where [Key] = 'falconGuid'

    select
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'channel') channel,
        'Yandex||Google||Youtube||Socials||Newtorking' example_channel,
        1 edt_channel,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'link') link,
        1 edt_link,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'negative') negative,
        1 edt_negative,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'positive') positive,
        1 edt_positive,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'mostinteresting') mostinteresting,
        1 edt_mostinteresting,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'notenough') notenough,
        1 edt_notenough,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'moreinformation') moreinformation,
        1 edt_moreinformation,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'alternative') alternative,
        1 edt_alternative,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'po') po,
        1 edt_po,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'like') [like],
        1 edt_like,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'email') email,
        1 edt_email,
        (select answer from falcon_clientQuestionaries where userGuid = @userGuid and question = 'phone') phone,
        1 edt_phone,
        '1' access,
        1 edt_access

    select 'line' progressType,
        iif(@langID=1, 'Getting a discount on Falcon Space (demo)', 'Получение скидки на Falcon Space (демо)') Title,
        iif(@langID=1, 'Your discount will be based on the completeness of your Falcon Space questions. <br />
Each questionnaire is checked manually after filling in and the amount of the discount is confirmed.', 'Ваша скидка будет зависеть от степени заполненности вопросов по Falcon Space. <br />
Каждая анкета проверяется после заполнения вручную и подтверждается размер скидки. ') Subtitle ,
        iif(@langID=1, 'Get discount', 'Получить скидку') ButtonText
END