select distinct isnull(t2.position_id,'') + '' + t2.last_name as [certifier name], t1.order_number as [order number] from shop.dbo.orders t1, shop.dbo.managers t2 where t2.manager_ssn in (select t1.manager_ssn_id from shop.dbo.orders) and t1.order_number collate database_default not in (select substring(t3.leafname,0,6) from server2.wsscontent.dbo.alldocs t3 where t3.dirname like 'intranet/supporting documents/%') and t1.manager_ssn_id = '' order by t1.order_number
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)