PD.Name0,
count(*)
from
dbo.v_GS_PRINTER_DEVICE PD
Group by
PD.Name0
Order by
PD.Name0
Report Count Local Printers
select Distinct
PD.Name0,
count(*)
from
dbo.v_GS_PRINTER_DEVICE PD
Group by
PD.Name0
Order by
PD.Name0
PD.Name0,
count(*)
from
dbo.v_GS_PRINTER_DEVICE PD
Group by
PD.Name0
Order by
PD.Name0
An error occurred when the report was run. The details are as follows:
ReplyDeleteInvalid column name 'Name0'.
Error Number: -2147217900
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 207