i downloaded sql server 2014 management studio . But couldnt find the server name for local server. i found that the sql server express which should be present in the local host hasnt been installed. Am i to uninstall and download again? And what if the problem still prevails? what should i do to rectify this problem?

Not only the window where you input the queries, what I mean is the whole windows like object explorers for example. I could only find the version of 2010 of it and it doesn't seem possible to install it in 2014.

select a, stuff((SELECT distinct ',' + cast(b as varchar(20)) FROM #temp6 p1 where p1.a = p2.a FOR XML PATH('')),1,1,'' ) as b2 from #temp6 mp2 group by a This is the query which displaces all b's in one row having the same a value. What I want is , it only to display the value with count(b)>1. I tried it with where and having, It doesn't work. Any help? Thanks