Eigene Übersichten für Kunden

SELECT 
			Art.cArtNr AS ArtNr,
			ArtBe.cName AS Artikelname,
			PrDet.nAnzahlAb AS "Preis ab Menge",
			CONVERT(DECIMAL(10, 2), PrDet.fNettoPreis) AS "Nettopreis",
			CONVERT(DECIMAL(10,2), PrDet.fNettoPreis * (100 + StS.fSteuersatz) / 100) AS "Bruttopreis"
FROM		dbo.tKunde AS K
JOIN		dbo.tPreis AS Pr ON Pr.kKunde = K.kKunde
JOIN		dbo.tPreisDetail AS PrDet ON PrDet.kPreis = Pr.kPreis
JOIN		dbo.tArtikel AS Art ON Art.kArtikel = Pr.kArtikel
JOIN		dbo.tSpracheUsed AS SprU ON nStandard = 1
JOIN		dbo.tArtikelBeschreibung AS ArtBe ON ArtBe.kArtikel = Art.kArtikel AND ArtBe.kSprache = SprU.kSprache AND ArtBe.kPlattform = 1 AND ArtBe.kShop = 0
OUTER APPLY	(SELECT TOP(1) Fi.cLandISO FROM dbo.tFirma AS Fi WHERE cAktiv = 'Y' ORDER by Fi.kFirma) AS F
JOIN		dbo.tSteuerzoneLand AS StZL ON StZL.cISO = F.cLandISO
JOIN		dbo.tSteuerzone AS StZ ON StZ.kSteuerzone = StZL.kSteuerzone AND StZ.kFirma = 0
JOIN		dbo.tSteuersatz AS StS ON StS.kSteuerzone = StZ.kSteuerzone AND StS.kSteuerklasse = Art.kSteuerklasse
WHERE		K.kKunde = @Key
ORDER BY	Art.cArtNr, PrDet.nAnzahlAb