I want to write an effective query instead of a loop and I have following data.
table : market_symbol
symbolid , type, country
I want to fetch all symbol data that are available in table market_symbol from function fetch_symbol_data like this
from market_symbol a
cross apply dbo.fetch_symbol_data(a.symbolid) b
this is working fine but I want to use a condition column as well in single query to fetch data on the basis of condition specified in condition column.