Hello everyone,
I am struggling with a SQL statement which works well in SSMS but gives syntax error in Power Automate Desktop. Here is my statement:
select TRIM(V.[NAME]) AS VENDORNAME, ISNULL(F.[NAME],'zz_Unknown') AS SOFTWARENAME, P.PATCHNAME, P.BULLETINID, L.[PATH] AS SOURCEPATH, D.[DESCRIPTION],
DATEADD(s, CAST(LEFT(CAST(D.[RELEASEDTIME] AS VARCHAR(100)), 10) AS INT), '1970-01-01 00:00:00')
AS DATERELEASED, P.ISSUPERCEDED, P.SUPERCEDEDBY
from Patch P
INNER JOIN Location L ON P.PATCHLOCATIONID = L.LOCATIONID
INNER JOIN Vendor V ON V.VENDORID = P.VENDORID
LEFT JOIN PatchDetails D ON D.PATCHID = p.PATCHID
LEFT JOIN Family F ON F.FAMILYID = P.FAMILYID
where L.[PATH] like '%.msi%' AND DATEADD(s, CAST(LEFT(CAST(D.[RELEASEDTIME] AS VARCHAR(100)), 10) AS INT), '1970-01-01 00:00:00') > '2022-03-14 00:00:00.000'
ORDER BY 7 desc --1,2
If you see on every apostrophe it is showing an error. Can someone help in correcting this?
