Skip to content

Instantly share code, notes, and snippets.

View svschannak's full-sized avatar

Sven Schannak svschannak

View GitHub Profile
@svschannak
svschannak / update_pickware.sql
Created June 14, 2019 12:44
update_pickware.sql
UPDATE db_web1_1.pickware_erp_warehouse_article_detail_configurations pew
JOIN (SELECT sod.name name,
pew.articleDetailId detailID,
pew.minimumStock minimumStock,
SUM(sod.quantity) sum_quantity
FROM db_web1_1.s_order_details sod
JOIN db_web1_1.s_order so ON sod.orderID = so.id
JOIN db_web1_1.s_articles_details sad ON sod.articleordernumber = sad.ordernumber
JOIN db_web1_1.s_articles_attributes saa ON sad.id = saa.articledetailsID
<pap name="Lohnsteuer2019Big" version="1.0" versionnummer="1.0">
<variables>
<!-- Stand: 2018-11-12 -->
<!-- ITZBund Düsseldorf-->
<!-- EINGABEPARAMETER -->
<inputs>
<!-- 1, wenn die Anwendung des Faktorverfahrens gewählt wurden (nur in Steuerklasse IV) -->
<input name="af" type="int" default="1"/>