Configure the lines on the Axess display

The Text3 line is now configurable by a new setting in _ax_settings. The default is to display the age. Users can also see the date of birth and height. To set it to display height, you would:

exec SiriusSP_Ax_SetValue @tcKeyName = 'DisplayTextSQL', @tcValue = 'isnull(''DOB: '' + convert(varchar, g.birth_date, 110), space(15)) + space(3) + isnull(''Height: '' + cast(cast

(g.height/12 as int) as varchar) + ''/'' + cast(g.height % 12 as varchar), space(12))'

To reset:

exec SiriusSP_Ax_SetValue @tcKeyName = 'DisplayTextSQL', @tcValue = '''Age: '' + case when g.birth_date is null then ''0'' else cast(datepart(yy, current_timestamp) - datepart(yy,

g.birth_date) - (case when substring(convert(char(8), current_timestamp, 112), 5, 4) < substring(convert(char(8), g.birth_date, 112), 5, 4) then 1 else 0 end) as varchar(10)) end'