MS SQL Server being used.
I need a query that will return an integer. I need all of the workstations that are not like %ThinkCentre% and assigned to these 4 departments.
'Inventory 1'
'Inventory 2'
'Inventory 3'
'Inventory 4'
I just need it to return a count. No header, no extras, just an integer. Please help!