select * from sys_dimenze where iddim in (4,5,7)

select * from sys_strom_dimenze where iddim = 4 and idstrom in (1,2,3,4,5,6)
select * from sys_strom_dimenze where iddim = 5 and idstrom in (1,2,3,4)
select * from sys_strom_dimenze where iddim = 7 and idstrom in (1,5,6)


-- Střediska
SELECT a.idstrom,case when Len(LTrim(RTrim(a.zis)))=0 OR a.zis is null THEN 'zis'+convert(varchar(27),a.code) ELSE a.zis END,a.nazev,
CASE WHEN a.iduroven=2 THEN '@NECHAT@KDE@JE@2' ELSE CASE WHEN b.nezar=1 THEN '@NECHAT@KDE@JE@' ELSE (case when Len(LTrim(RTrim(b.zis)))=0 OR b.zis is null THEN 'zis'+convert(varchar(27),b.code) ELSE b.zis END) END END as zis_parenta,a.list
FROM dim_nazevcode a, dim_zis b, dim_zis c
WHERE a.iddim = 4  and a.idstrom in (1,2,3,4,5,6)
AND a.iddim = b.iddim AND a.parent = b.code
AND a.iduroven > 1
AND a.iddim = c.iddim AND a.code = c.code AND c.nezar<>1

-- Zakázkový typ
SELECT a.idstrom,case when Len(LTrim(RTrim(a.zis)))=0 OR a.zis is null THEN 'zis'+convert(varchar(27),a.code) ELSE a.zis END,a.nazev,
CASE WHEN a.iduroven=2 THEN '@NECHAT@KDE@JE@2' ELSE CASE WHEN b.nezar=1 THEN '@NECHAT@KDE@JE@' ELSE (case when Len(LTrim(RTrim(b.zis)))=0 OR b.zis is null THEN 'zis'+convert(varchar(27),b.code) ELSE b.zis END) END END as zis_parenta,a.list
FROM dim_nazevcode a, dim_zis b, dim_zis c
WHERE a.iddim = 5  and a.idstrom in (1,2,3,4)
AND a.iddim = b.iddim AND a.parent = b.code
AND a.iduroven > 1
AND a.iddim = c.iddim AND a.code = c.code AND c.nezar<>1

-- Účet
SELECT a.idstrom,case when Len(LTrim(RTrim(a.zis)))=0 OR a.zis is null THEN 'zis'+convert(varchar(27),a.code) ELSE a.zis END,a.nazev,
CASE WHEN a.iduroven=2 THEN '@NECHAT@KDE@JE@2' ELSE CASE WHEN b.nezar=1 THEN '@NECHAT@KDE@JE@' ELSE (case when Len(LTrim(RTrim(b.zis)))=0 OR b.zis is null THEN 'zis'+convert(varchar(27),b.code) ELSE b.zis END) END END as zis_parenta,a.list
FROM dim_nazevcode a, dim_zis b, dim_zis c
WHERE a.iddim = 7  and a.idstrom in (1,5,6)
AND a.iddim = b.iddim AND a.parent = b.code
AND a.iduroven > 1
AND a.iddim = c.iddim AND a.code = c.code AND c.nezar<>1