Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have an app in which i'm executing a sql query and then storing its data in a qvd file. For the sake of simplicity, it something like that;
In this query i'm checking if a string in table2 contains any substring in cte table's words_ column. I have more than one cte blocks like that and more than one apply operator which do the same thing like in this picture.
So what do i want to do is that seperating those cte blocks and store every one of them in seperate qvd files. Then apply the same logic but with taking the data from the seperate qvd files. Basically, i want to use the logic behind the apply here and then use 'like' operator to specify the condition.
Thanks for your reply.
But it doesn't check whether a string from table2 includes a substring from table1. It gives result if only two fields are exactly same.