I want to write an effective query instead of a loop and I have following data.
table : market_symbol
symbolid condition
10001 type=1
20001 country='IN'
function: fetch_symbol_data(symbolid)
function returns:
symbolid , type, country
I want to fetch all symbol data that are available in table market_symbol from function fetch_symbol_data like this
select b.*
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.
please suggest.