https://prirucky.ksprogram.cz/index.php?action=history&feed=atom&title=Seznam_penzijn%C3%ADch_a_%C5%BEivotn%C3%ADch_fond%C5%AF_%28sestava%29 2026-10-17T09:49:32Z Historie editací této stránky MediaWiki 1.37.2 https://prirucky.ksprogram.cz/index.php?title=Seznam_penzijn%C3%ADch_a_%C5%BEivotn%C3%ADch_fond%C5%AF_(sestava)&diff=46901&oldid=prev 2024-08-30T08:26:52Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="cs"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Starší verze</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Verze z 30. 8. 2024, 10:26</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l5">Řádek 5:</td> <td colspan="2" class="diff-lineno">Řádek 5:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;small&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;small&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  select A.id_podniku, A.id_osoby, A.ico, A.nazev, A.nazev_zkr, B.typ, B.c_pole2, B.c_pole3, B.n_pole3, B.n_pole4</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  select A.id_podniku, A.id_osoby, A.ico, A.nazev, A.nazev_zkr, B.typ, B.c_pole2, B.c_pole3, B.n_pole3, B.n_pole4</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  from osoby A, osoby_typ B where A.id_osoby = B.id_osoby and B.typ in ('pf', 'zf')</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  from osoby A, osoby_typ B where A.id_osoby = B.id_osoby and B.typ in (<ins style="font-weight: bold; text-decoration: none;">'af', 'bf', </ins>'pf<ins style="font-weight: bold; text-decoration: none;">', 'ef</ins>', 'zf')</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  order by B.c_pole2;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  order by B.c_pole2;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/small&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/small&gt;</div></td></tr> <!-- diff cache key wikidb_1372:diff::1.12:old-44824:rev-46901 --> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=Seznam_penzijn%C3%ADch_a_%C5%BEivotn%C3%ADch_fond%C5%AF_(sestava)&diff=44824&oldid=prev 2023-05-22T08:15:33Z

<p>založena nová stránka s textem „&#039;&#039;Seznam penzijních a životních fondů (sestava)&#039;&#039; je sestava pro <a href="/index.php?title=Gener%C3%A1tor_sestav_II" title="Generátor sestav II">Generátor sestav II</a>. <a href="/index.php?title=Soubor:Seznam_penzijnich_a_zivotnich_fondu.png" title="Soubor:Seznam penzijnich a zivotnich fondu.png">right|690px</a> == Definice == &lt;small&gt; select A.id_podniku, A.id_osoby, A.ico, A.nazev, A.nazev_zkr, B.typ, B.c_pole2, B.c_pole3, B.n_pole3, B.n_pole4 from osoby A, osoby_typ B where A.id_osoby = B.id_osoby and B.typ in (&#039;pf&#039;, &#039;zf&#039;) order by B.c_pole2; &lt;/small&gt; == Odkazy == * Generátor sestav II (příkl…“</p> <p><b>Nová stránka</b></p><div>''Seznam penzijních a životních fondů (sestava)'' je sestava pro [[Generátor sestav II]].<br /> [[Image: Seznam penzijnich a zivotnich fondu.png|right|690px]]<br /> <br /> == Definice ==<br /> &lt;small&gt;<br /> select A.id_podniku, A.id_osoby, A.ico, A.nazev, A.nazev_zkr, B.typ, B.c_pole2, B.c_pole3, B.n_pole3, B.n_pole4<br /> from osoby A, osoby_typ B where A.id_osoby = B.id_osoby and B.typ in ('pf', 'zf')<br /> order by B.c_pole2;<br /> &lt;/small&gt;<br /> <br /> == Odkazy ==<br /> * [[Generátor sestav II (příklady sestav)]]<br /> * &lt;small&gt;hd 66497&lt;/small&gt;</div>

Petrm