FROM vt_notdisp_ship_to a,
WHERE (a.ship_to_addr <>'''' AND a.ship_to_addr LIKE ('%b.ship_to_addr%'))
OR (a.ship_to_code <> '''' AND a.ship_to_code LIKE ('%b.ship_to_code%'))
QUALIFY ROW_NUMBER() OVER (ORDER BY a.amount DESC) <=10;
I am having a query like above, but i couldnt able to get the result, as after the like cmd, i am having a column from b table, if it a local or input variable, the above will execute correctly.
Can you please guide me how to use like on column in dynamic cursor.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.