Hot answers tagged sql-server
Try it with getdate() ExprDate <= (GETDATE() + 30) AND ExprDate >= GETDATE()
I suggest to use the SQL Server express that is accompanied with the ArcGIS Installation media (DVD) and stay away from newer versions of SQL Server for this purpose. If you downloaded the installation file from the Esri Customer Care portal, unzip the file and run the ESRI.exe. If you have an ISO file, use an ISO extractor to access the installation files ...
Only top voted, non community-wiki answers of a minimum length are eligible