7 lines
248 B
Transact-SQL
7 lines
248 B
Transact-SQL
SELECT [pos].[POS_hostname], [pos].[POS_MAC_address], [pos].[POS_number], [pos].[POS_type]
|
|
FROM [Arizona].[dbo].[Point_of_sale] [pos]
|
|
WHERE [pos].[POS_active]=1
|
|
AND [pos].[POS_type] IN (1,2)
|
|
AND [pos].[POS_number] < 99
|
|
ORDER BY [pos].[POS_number]
|
|
; |