USE [Datenbank]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ViewName]
AS
SELECT MetaInspectionID, InspectionName, substring(ClassName,1,3) AS FKey, StartTimeLocal, SUM(DefectCount) AS Anzahl
FROM SZFG.dbo.vc_SZFG_Coilfehler
WHERE ViewBaseName='Obersicht'...