Mar-17-2021, 03:24 PM
I'd like to make a SQL-request.
In the mooment SQL-approach and the request are working well.
In the cursor.execute command i coded a static string with an item-number '894204'.
Now I like to change this number dynamically.
How to to this? It's perhaps a silly question for you, but I'm a beginner.
In the mooment SQL-approach and the request are working well.
In the cursor.execute command i coded a static string with an item-number '894204'.
Now I like to change this number dynamically.
How to to this? It's perhaps a silly question for you, but I'm a beginner.
import sys from os import getenv import pymssql import time import numpy as np import array from re import sub import openpyxl import subprocess # Definition vo Variablen und Felder ... conn = pymssql.connect(server="server" , user="mustermann", password="passwort") cursor = conn.cursor() cursor.execute("""SELECT convert(NVARCHAR,b.[Posting Date],104) as Datum ,b.[Posting Date] ,[No_] as Artikel# ,a.[DescriptionFUll] ,b.[Document No_] ,b.[Entry Type] ,"Vorgang" = case when [Entry Type]=0 then 'Einkauf' when [Entry Type]=1 then 'Verkauf' when [Entry Type]=2 then 'Zugang' when [Entry Type]=3 then 'Abgang' when [Entry Type]=4 then 'Umlagerung' when [Entry Type]=5 then 'Verbrauch' when [Entry Type]=6 then 'Istmeldung' when [Entry Type]=7 then 'N.N' when [Entry Type]=8 then 'Verbrauch für Montage' when [Entry Type]=9 then 'Montage-Istmeldung' end ,cast(round(b.[Quantity],2,2) as real) as Menge ,[Base Unit of Measure] ,cast(round([Unit Cost],2) as real) as 'EuroProEinheit' ,[Blocked] ,cast(round([Lot Size],2,2) as real) as Losgröße ,cast(round([Safety Stock Quantity],2,2)as real) as Sich_Bestand ,[Zeichnungsnummer] ,[Inventur] ,[Blocked Purchase] FROM [Mustermann BC].[dbo].[Mustermann_GmbH$Item] as a LEFT JOIN [Mustermann BC].[dbo].[Mustermann_GmbH$Item Ledger Entry] AS b ON a.No_ = b.[Item No_] where No_ like '894204'""")