Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature may not be available in some browsers.
SELECT
[Element] as [Artikelnummer],
sum( [Menge] * [BelFak] ) as [BedarfsMenge],
convert( varchar, min([Datum]), 104 ) as [DateFirst],
convert( varchar, max([Datum]), 104 ) as [DateLast]
--,*
FROM (
SELECT
[iA].[BelID]
,[iA].[MengeBasis] as [BelFak]
,[iA].[Liefertermin] as [Datum]
,[iA].[Hauptartikelgruppe] as [HAGruppe]
,[iA].[Artikelnummer] as [FA-Artikel]
,[iA].[Bezeichnung1] + ISNULL(' ' + [iA].[Bezeichnung2], '') as [Bez]
,[AS].[Element]
,[iA].[Artikelnummer]
,[AS].[Menge]
FROM [PaulyLive].[dbo].[KHKIFAuftraege] as [iA]
LEFT JOIN [PaulyLive].[dbo].[KHKArtikelStueckliste] as [AS] ON [iA].[Artikelnummer] = [AS].[Stueckliste]
) as q
GROUP BY [Element]
ORDER BY [Element]