This is using XML feature of the SQL server. (nothing new here)
select Type, RestaurantNames from Restaurant AS A CROSS APPLY (SELECT RestaurantName + ',' FROM Restaurant AS B WHERE A.Type = B.Type FOR XML PATH('')) D (RestaurantNames) GROUP BY Type, RestaurantNames
This is to get something like below (similar to MYSQL GROUP_CONCAT)
Type |RestaurantNames ----- --------------- Chinese Food | Ah Yat Abalone, Liang Yah Yong Tau Foo, Indian Food | Kanna Curry House, Western Fast Food | Burger King, McDonald
instead of multiple rows.
like Type |RestaurantName ----- --------------- Chinese Food |Ah Yat Abalone Chinese Food |Liang Yah Yong Tau Foo Indian Food |Kanna Curry House
My team members were asking me about how come their files can't be modified and etc even if it is a duplicated local copy. I tried it out and realized it is indeed not working as told. My finding was that the TFS has a tight control on the versioning of the file, even if the files are offline or those files are duplicate copies of the original files, the TFS control still present in every aspects of the actions you want to do onto those files.
So, it seems like there need to have an official declaration to inform Visual Studio that the project files are out of the TFS radar. After some internet searches and trials, it seems like to "permanently" detach project file from TFS are not so straightforward and not properly documented too. It requires some kind of hacking seems.
Below are the steps required after the files get copied out from the TFS.
1. Change all the files from readonly to non-readonly.
2. Remove your local workspace from the Visual Studio.
Go to menu it…