I have read numerous article and different blogs of SQL Server . I have an unique problem in this case. Let me explain you my problem statement.
I have many tables and i cannot union it all.
So, i am trying to get the one column value (It can be string or null value)if the value doesn't exist in table 1, then it will go the another table and scan the whole table to find the value. If it doesn't exist in 2nd table, it will scan the table 3 and it goes on.. Untill it find that value.
Please help me writing either case statement or if else statement in SQL