Rohit Dhand

Microsoft is embedding the tile based user interface not in only in XBOX or next gen Windows, rather it is being tested on the web also. The screenshot given below shows how exactly it looks like: If somebody wants to see the action for himself/herself, please follow the link below and give me your valuable opinion: http://www.microsoft.com/windows/windowslive/whatsyourinboxlike/ Hope this tile based interface brings uniformity in all the Microsoft products.

There are situations when we want the data to be presented in the comma separated values rather than individual rows. For e.g. see the data in the pic given below: The above shows all Enames with its deptno. But the employees for each deptno is represented as an individual row. Now if we want to display the same data with comma separated values given in the screenshot below: In order to achieve this, we can use the XML Path function in SQL Server. This will help in generating the individual values and we can separate individual values with the help of comma or any other identifier. The query to generate the above resultset is: In the above query we have used substring function so as to remove the "," which comes at the start of every name. The above is a wonderful tool to rearrange the values in the form of comma separated values.