VERIFIED SOLUTION i

How to extract job from SQL database based on company name

Following is the SQL query syntax to be run at Microsoft SQL Server Management Studio to extract job from SQL database based on CompanyName between specific ReceivedDate:

Select * FROM [PIOfficeMail].[dbo].[Job] where CompanyName like '<company name>' 
    and ReceivedDate between '<year>/<month>/<date>' and '<year>/<month>/<date>'

Following example is to extract job for company name of "Sample Company" between (and included) 1st of April to 30th of April 2017:
Select * FROM [PIOfficeMail].[dbo].[Job] where CompanyName like '%Sample Company%' 
    and ReceivedDate between '2017/04/01' and '2017/04/30'

Please verify and contact the Software Support Team at software.support@pb.com if you have any query.

 
Environment Details
Products Affected: OfficeMail
 
UPDATED:  July 25, 2018