Resolution | Select M.module_name as 'Application Name', L.level_name as 'Level Name', FD.field_name as 'Field Name', FT.field_type_name as 'Field Type', c.calc_order as 'Calculation order', c.formula as 'Formula', c.enforce_calc as 'Always Calculate', c.is_handle_error as 'Display novalue/specific error', CEV.numeric_value as 'Specific error value_Numeric', CEV.select_value_id as 'Specific error value_list', Cev.string_value as 'Specific error value_text', CEV.date_value as 'Specific error value_Date' from tblIVFieldDef FD join tblLevel L on L.level_id=FD.level_id join tblModule M on M.module_id=L.module_id join tblIVFieldType FT on FT.field_type_id=FD.field_type_id join tblCalc C on C.field_id=FD.field_id full outer join tblCalcErrorValue CEV on FD.field_id=CEV.field_id order by module_name,level_name,calc_order |