asked on
ASKER
ASKER
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
TRUSTED BY
I would bite the chunk in small pieces. If you are proficient at it (very simple, actually) write a scalar function which would return the string you are referring to, something like this:
Open in new window
where @RegionName will be passed as a parameter. Issue resolved for the 1 row in the table.
Should you need entire result set in one use following, assuming above query is in function fnGetTeams:
Open in new window
Please give more meaningful names.