New answers tagged

0

If you have a somewhat limited number of tables that could be returned by the query, you could have the query select from all of them, but only return results for the one matching the data returned by the table1/table2 query. That would look something like this: With TableVariable As ( SELECT table_name FROM table2 WHERE mi_prinx=( SELECT mip1 ...


0

This is always a tricky one! Luckily, there's a solution! I had this problem before and solved it using a "shadow" or "search" column. Here in Ireland, it's very common to have names with many different variations depending on accent or capitalisation. Indeed, the same person can have different spellings for various reasons. What we did was to have a "...



Top 50 recent answers are included