InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 04:32:56 GMT20http://www.sqlservercentral.com/Forums/Topic1413985-169-1.aspx[code="sql"]declare @tab table (col1 char(2))insert into @tab values('A1'),('A2'),('A3'),('B1'),('B2'),('B3')SELECT A.Col1, B.Col1FROM( SELECT ROW_NUMBER() OVER(PARTITION BY LEFT(Col1,1) ORDER BY Col1) AS RowNum, Col1 FROM @tab WHERE LEFT(Col1,1) = 'A') AS AFULL OUTER JOIN( SELECT ROW_NUMBER() OVER(PARTITION BY LEFT(Col1,1) ORDER BY Col1) AS RowNum, Col1 FROM @tab WHERE LEFT(Col1,1) = 'B') AS BONA.RowNum = B.RowNum[/code]Thu, 31 Jan 2013 04:43:55 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1413985-169-1.aspxI am Ramanathan and working in SQL SERVER 2008….Please help meTable1Location--FieldA1A2A3B1B2B3How to change an below format from table1A B--FieldA1 B1A2 B2A3 B3Thu, 31 Jan 2013 04:22:04 GMTramanathan.raman88