Lotsia PLM: Форум по семейству систем PLM/PDM/TDM/ERP/Workflow

Код: Выделить всё

 select * --lsdbo.wf_map_vars_v.var_value
         from lsdbo.wf_map_vars_v
        where lsdbo.wf_map_vars_v.map_id = 100007304500017

Код: Выделить всё

SELECT 
mv.map_id,
    mv.var_name,
    0,
    mv.var_type,
    mv.var_visible,
    mv.var_value_type,
    case when mvm.mail_id is null then mv.var_value else mvm.var_value end,
    mv.description,
    mvm.mail_id,
    od.value_n,
    od.value_t
  FROM lsdbo.our_dummy od, lsdbo.wf_map_vars_v mv
    left outer join lsdbo.wf_map_vars_mail_v mvm on 
      mvm.map_id = mv.map_id AND mvm.var_name = mv.var_name --AND
     -- mvm.mail_id = 2583
  WHERE mv.map_id = 100007304800017

Код: Выделить всё

select * --lsdbo.wf_map_vars_v.var_value
         from lsdbo.wf_map_vars_mail_v
        where 
              lsdbo.wf_map_vars_mail_v.map_id = 100007304800017

Код: Выделить всё

var_name   mail_id    var_value
idCard	  2587	    100007305700017
idCard	  2588	    100007305700017
msg	     2587	    '11 работы'
msg	     2588	    '11234 работы'

Код: Выделить всё

select top(1) with ties *
from lsdbo.wf_map_vars_mail_v
where map_id = 100007305700017
order by row_number()over(partition by var_name order by mail_id desc);