Querying Global and Local Description

In the standard client functionality, the LanguageNumber parameter determines whether the global or local descriptions will be used but the value of the LanguageNumber itself (for example, which language is configured for the user) has no effect on the selection. If the LanguageSetting site parameter is different than the user's LanguageSetting parameter, then the user will see the global descriptions, is there are any. If there are no global descriptions, then the user will see the local descriptions. If the LanguageSetting site parameter is the same as the user's LanguageSetting parameter, then the user will see the local descriptions.

For example,

DECLARE @SiteLanguageId INT, @UserLanguageId INT;
                            SELECT  @SiteLanguageId=CONVERT(INT, VALUE)
                            FROM  Site_Parameters
                            WHERE  Parm_Id=8;
                            SELECT @UserLanguageId=COALESCE(COVERT(INT, Value), @SiteLanguageId)
                            FROM User_Parameters
                            WHERE  Parm_Id=8 AND User_Id=1;
                            SELECT
                                  CASE
                                       WHEN @UserLanguageId<>@SiteLanguageId OR @UserLanguageId IS NULL
                                               THEN COALESCE(Var_Desc_Global, Var_Desc_Local)
                                  END
                            FROM Variables
                            WHERE Var_Id-50;