SELECT ListItem as ColumnName from ( SELECT REPLACE(ColumnsList, '$', ListItem) ListItem FROM dbo.MODELS_COLUMNS_STRUCTURE MCS CROSS JOIN List_Resources WHERE Type = 'country data' ) A
Country Country Country Region Region Region Currency Currency Currency Allocation Allocation Allocation Business Business Business CurrencyUSDRate CurrencyUSDRate CurrencyUSDRate CurrencyAUDRate CurrencyAUDRate CurrencyAUDRate CurrencyEURRate CurrencyEURRate CurrencyEURRate
Country Region Currency Allocation Business CurrencyUSDRate CurrencyAUDRate CurrencyEURRate
SELECT DISTINCT ListItem as ColumnName from ( SELECT REPLACE(ColumnsList, '$', ListItem) ListItem FROM dbo.MODELS_COLUMNS_STRUCTURE MCS CROSS JOIN List_Resources WHERE Type = 'country data' ) A
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)