The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.
select JOBNUMBER,CRDATE,CONVERT(CHAR(15),AGENCY) AS AGENCY from [gseappserver\sql2000].[gse2000sql].[dbo].[jobs] where jobnumber not in ( select pacontid from [gseappserver].[gse].[dbo].[pa01101]) and contractcomplete=0