Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
that in case the wording is found then instead of selecting where datefields >= '1/1/16', I want to put the following "EmployeeID in (select id from employeestbl where datefields >= '1/1/16')"
SELECT * FROM Wordings WHERE ISNULL( DateFields , '' ) >= CASE WHEN Wording LIKE '%My Wording%' THEN '1/1/16' ELSE ISNULL(DateFields ,'') END
|Two tables - Sum of values - What is the difference||31||47|
|Query criteria to get previous month's data not working||3||27|
|mySQL. SQL query. Substitute for Numeric key word.||3||34|
|Very interesting Access query problem.||13||43|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!