-- Count Distinct Values in Multiple Columns;WITH CTE AS(SELECT ROW_NUMBER() OVER(PARTITION by Name order by Name) AS ColName, ROW_NUMBER() OVER(PARTITION by AreaCode order by AreaCode) AS ColAreaFROM #TT)

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.