Enhacned Query for convert Customquery to EQ

[NardnraP]

Hi,

please can you provide EQ query for below sql update query

update arstasks a set a.STATUS = 3,a.provisioningcomments ='No Action Required' where a.taskkey in (1231,1241,1243,1244)

[Raghu · Accepted solution]

@NardnraP  try below

SELECT '3' AS ARSTASKS__STATUS,'No Action Required' AS ARSTASKS__PROVISIONINGCOMMENTS ,A.TASKKEY AS ARSTASKS__PRIMARYKEY FROM ARSTASKS A WHERE A.TASKKEY in (1231,1241,1243,1244)

[NardnraP]

Thanks @Raghu .