Die Sicht V_EmptyPagesPerDocument
Diese Sicht enthält je Basisdokument die Anzahl Blätter, Seiten, Bilder
und die leeren Seiten.
|
DateOnly | Datum der Verarbeitung. |
ClientName | Der Name des Mandanten (Client in V_StepsReports). |
ClientID | ID des Mandanten (ID in C_Client). |
ProcessName | Der Name des Prozesses (Process in V_StepsReports). |
ProcessID | ID des Prozesses (ID in C_Process). |
BatchID | ID des Basisdokuments (BatchID in V_StepsReports). |
SheetNo | Anzahl Blätter je Dokument. |
PageNo | Anzahl Seiten je Dokument. |
PageEmpty | Anzahl leere Seiten je Dokument. |
ImageNo | Anzahl Bilder je Dokument. |
SQL Skript
CREATE VIEW
[dbo].[V_EmptyPagesPerDocument]
AS SELECT DISTINCT
dbo.V_StepsReports.DateOnly, dbo.C_Client.Name AS ClientName, dbo.C_Client.ID
AS ClientID, dbo.C_Process.Name AS ProcessName, dbo.C_Process.ID AS
ProcessID, dbo.W_Document.BatchID,
(SELECT COUNT(*) AS Expr1
FROM dbo.W_Sheet
WHERE (BatchID = dbo.W_Document.BatchID))
AS SheetNo,
(SELECT COUNT(*) AS Expr1
FROM dbo.W_Page
WHERE (BatchID = dbo.W_Document.BatchID))
AS PageNo,
(SELECT COUNT(*) AS Expr1 FROM dbo.W_Page AS W_Page_1
WHERE (BatchID = dbo.W_Document.BatchID) AND (Empty = 1)) AS PageEmpty,
(SELECT COUNT(*) AS Expr1
FROM dbo.W_Image
WHERE (BatchID = dbo.W_Document.BatchID))
AS ImageNo
FROM
dbo.C_Process INNER JOIN
dbo.C_Client ON
dbo.C_Client.ID = dbo.C_Process.ClientID INNER JOIN
dbo.W_Document ON
dbo.C_Process.ID = dbo.W_Document.ProcessID INNER JOIN
dbo.V_StepsReports ON
dbo.W_Document.ID = dbo.V_StepsReports.DocumentID
Anwendung