-- Replace:
-- 3x columnName (Column field value in Custom fields property definition – real column name in db, not Custom field name property)
-- 1x ticketId (etc 777)
-- 1x localeId (etc 1029 for CZ or 1033 for EN)

select
	case 
		when c.bUseColumnValue = 1 and c.Type = 'int' then 
            (select cv.LocalizedColumnValue from vColumnValueLoc cv where cv.liColumnId = c.iColumnId and cv.iColumnValueId = tc.[{columnName}] and cv.ColumnValueLocaleId = localeId)
		else
			cast(tc.[columnName] as nvarchar(max))
	end as [value]
from tHdTicketCust tc
left join tColumn c on c.sTable = N'tHdTicketCust'
where tc.liHdTicketId = ticketId and c.sColumn = 'columnName'