https://prirucky.ksprogram.cz/index.php?action=history&feed=atom&title=Odstupn%C3%A9_jako_n%C3%A1sobek_pr%C5%AFm%C4%9Brn%C3%A9ho_v%C3%BDd%C4%9Blku_%28sestava%29 2026-10-17T05:52:47Z Historie editací této stránky MediaWiki 1.37.2 https://prirucky.ksprogram.cz/index.php?title=Odstupn%C3%A9_jako_n%C3%A1sobek_pr%C5%AFm%C4%9Brn%C3%A9ho_v%C3%BDd%C4%9Blku_(sestava)&diff=31363&oldid=prev 2017-06-02T09:32:06Z

<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 2. 6. 2017, 11:32</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3">Řádek 3:</td> <td colspan="2" class="diff-lineno">Řádek 3:</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>[[Image: Odstupne-jako-nasobek-prumerneho-vydelku.png|980px]]</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>[[Image: Odstupne-jako-nasobek-prumerneho-vydelku.png|980px]]</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;"><br/></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;"><br/></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>Sestava primárně určená pro MS SQL platformu (pokud by se upravily nebo odmazaly příkazy ceiling a round, pak i pro ostatní platformy).</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>Sestava primárně určená pro MS SQL platformu (pokud by se upravily nebo odmazaly příkazy ceiling a round<ins style="font-weight: bold; text-decoration: none;">, isnull, nullif</ins>, pak i pro ostatní platformy).</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;"><br/></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;"><br/></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.os_cislo, A.prijmeni, A.jmeno, P.cislo_pom,</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.os_cislo, A.prijmeni, A.jmeno, P.cislo_pom,</div></td></tr> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=Odstupn%C3%A9_jako_n%C3%A1sobek_pr%C5%AFm%C4%9Brn%C3%A9ho_v%C3%BDd%C4%9Blku_(sestava)&diff=31362&oldid=prev 2017-06-01T12:38:16Z

<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 1. 6. 2017, 14:38</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l10">Řádek 10:</td> <td colspan="2" class="diff-lineno">Řádek 10:</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>  ceiling(Z.hod_uvazek * Z.prum_dov * 21.74) as A1_A2_A3_Vypoc_1mes,</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>  ceiling(Z.hod_uvazek * Z.prum_dov * 21.74) as A1_A2_A3_Vypoc_1mes,</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>  ceiling(P.castka) as Castka,  </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>  ceiling(P.castka) as Castka,  </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>  ceiling(P.castka/(Z.hod_uvazek * Z.prum_dov * 21.74)) as podil_cely,</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>  ceiling(P.castka/<ins style="font-weight: bold; text-decoration: none;">(isnull (nullif </ins>(Z.hod_uvazek * Z.prum_dov * 21.74<ins style="font-weight: bold; text-decoration: none;">, 0), 1)</ins>)) as podil_cely,</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>  (P.castka/(Z.hod_uvazek * Z.prum_dov * 21.74)) as podil_desetinny</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>  (P.castka/<ins style="font-weight: bold; text-decoration: none;">(isnull (nullif </ins>(Z.hod_uvazek * Z.prum_dov * 21.74<ins style="font-weight: bold; text-decoration: none;">, 0), 1)</ins>)) as podil_desetinny</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>   </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>   </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>  from pracovnici A, pichacky P, pom_zal Z where  </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>  from pracovnici A, pichacky P, pom_zal Z where  </div></td></tr> </table>

Petrm https://prirucky.ksprogram.cz/index.php?title=Odstupn%C3%A9_jako_n%C3%A1sobek_pr%C5%AFm%C4%9Brn%C3%A9ho_v%C3%BDd%C4%9Blku_(sestava)&diff=31359&oldid=prev 2017-06-01T11:39:30Z

<p>Založena nová stránka: &#039;&#039;Odstupné jako násobek průměrného výdělku (sestava)&#039;&#039; - sestava pro <a href="/index.php?title=Gener%C3%A1tor_sestav_II" title="Generátor sestav II">Generátor sestav II</a>. Určuje kolikanásobný měsíční průměrný výdělek představova…</p> <p><b>Nová stránka</b></p><div>''Odstupné jako násobek průměrného výdělku (sestava)'' - sestava pro [[Generátor sestav II]]. Určuje kolikanásobný měsíční průměrný výdělek představovala poskytnutá částka odstupného. Zobrazuje všechny záznamy odstupného z celé historie (v příkladu mzdová položka 622).<br /> <br /> [[Image: Odstupne-jako-nasobek-prumerneho-vydelku.png|980px]]<br /> <br /> Sestava primárně určená pro MS SQL platformu (pokud by se upravily nebo odmazaly příkazy ceiling a round, pak i pro ostatní platformy).<br /> <br /> select A.os_cislo, A.prijmeni, A.jmeno, P.cislo_pom,<br /> Z.datum_nastupu, Z.datum_ukonc, P.kod, P.datum, <br /> Z.hod_uvazek as A1_hod_uvazek , Z.prum_dov as A2_prum_dov, 21.74 as A3_konst, <br /> ceiling(Z.hod_uvazek * Z.prum_dov * 21.74) as A1_A2_A3_Vypoc_1mes,<br /> ceiling(P.castka) as Castka, <br /> ceiling(P.castka/(Z.hod_uvazek * Z.prum_dov * 21.74)) as podil_cely,<br /> (P.castka/(Z.hod_uvazek * Z.prum_dov * 21.74)) as podil_desetinny<br /> <br /> from pracovnici A, pichacky P, pom_zal Z where <br /> A.os_cislo = P.os_cislo and <br /> P.os_cislo = Z.os_cislo and <br /> P.cislo_pom = Z.cislo_pom and <br /> P.datum = Z.datum and<br /> P.kod in (622);<br /> <br /> == Odkazy ==<br /> * [[Odstupné]]<br /> * [[Generátor sestav II]]</div>

Petrm