15 May 2014 by Maciej Los
Pivot[^] is that what you want ;)[EDIT]CREATE TABLE #tmp (SrNo INT IDENTITY(1,1), URL VARCHAR(50), VisDate DATETIME, Visits INT)SET DATEFORMAT mdy;INSERT INTO #tmp (URL , VisDate , Visits)VALUES('gmail.com', '4/1/2014', 5),('facebook.com', '4/1/2014', 1),('twitter.com',...