Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone help me to get the correct dynamic update syntax here
These don't seem to work
UPDATE TABLENAME SET GROUPID = 1 WHERE ID IN (1,2,3,4);
UPDATE TABLENAME SET GROUPID = 1 WHERE ID=1 OR ID=2 OR ID=3 OR ID=4;
Thanks in advance!
Felix
Hi Richard,
I have tried with the first one update query it is working perfectly,
Kindly try once again with
Update <tablename> set <fieldname> =<value> where <fieldname> in (<values for condition>);
Example I have used the below expression,
Update dbo.tbl_Womens_Registration set emp_Id =1 where emp_id in(101,102,103);
and got output as shown below
That works, as you have demonstrated, in SQL. I'm talking about Qlikview Dynamic Updates