SQL
USE [PrintMonitor]
GO
/****** Object:  View [dbo].[PAGES PRINTED BY PAPER SOURCE]    Script Date: 10/15/2008 21:49:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[PAGES PRINTED BY PAPER SOURCE]
AS
SELECT     TOP (100) PERCENT dbo.[Print Jobs].[User name], dbo.Printers.Name AS [Printer Name], dbo.[Print Jobs].[Paper Source]
FROM         dbo.[Print Jobs] INNER JOIN
                      dbo.Printers ON dbo.[Print Jobs].[Printer Id] = dbo.Printers.Id
GROUP BY dbo.[Print Jobs].[User name], dbo.Printers.Name, dbo.[Print Jobs].[Paper Source]
ORDER BY dbo.[Print Jobs].[User name], [Printer Name]

Last edited Oct 15, 2008 at 8:50 PM by Merrion, version 1

Comments

No comments yet.