SQL 2019 query
Budget: $10 – $30 USD
I am looking for a freelancer to update a query that worked in older version of SQL and does not work on SQL 2019 with a specific structure. The query should be relatively simple, the query should be an Update Query. the freelancer should have experience with SQL query . This project should take no longer than one day to complete.
Select TOP 1 Value INSVALUE
From [Project_320].[dbo].[Installation] WITH [NOLOCK]
WHERE [INSSECTION] ="DISABLED" AND replace ([INSIDENT],'-','') ='$S_DATE$'
The Select statement above used to return INSVALUE of 1 when the INSIDENT equaled the system date and no longer works, something has changed and I am not that familar with SQL.
The format for INSIDEN is MM/DD/YYYY 12:00 00 AM and the value of S_DATE is YYYYMMDD
Requesting to structure the query so that when INSIDENT is equal to S_DATE the query will return the value of INSVALUE
Select TOP 1 Value INSVALUE
From [Project_320].[dbo].[Installation] WITH [NOLOCK]
WHERE [INSSECTION] ="DISABLED" AND replace ([INSIDENT],'-','') ='$S_DATE$'
The Select statement above used to return INSVALUE of 1 when the INSIDENT equaled the system date and no longer works, something has changed and I am not that familar with SQL.
The format for INSIDEN is MM/DD/YYYY 12:00 00 AM and the value of S_DATE is YYYYMMDD
Requesting to structure the query so that when INSIDENT is equal to S_DATE the query will return the value of INSVALUE