I want to move Rows to Column

Question

I am new to SQL and want to convert row to column. I have a table like below:

Name	Metrics	Period	estimate
BAV	FFO	31-Dec-09	0.42
BAV	AFFO	31-Dec-09	0.97
BAV	AFFO	31-Dec-10	0.7
BAV	EBDA	31-Dec-09	679000
APB	FFO	31-Dec-09	0.5
APB	AFFO	31-Dec-09	1.02
APB	AFFO	31-Dec-10	0.9
APB	EBDA	31-Dec-09	800000

i want to convert it in below format:

	2009 FFO	2009 AFFO	2010 AFFO	2009 EBDA
BAV	0.42	0.97	0.7	679000
APB	0.5	1.02	0.9	800000

Thanks in advance for your help.

Answer 1

Hi,

This forum is for SQL Data Services, a Microsoft's Cloud database service offering. For any SSIS related query, you will have a better chance of getting a fast answer in one of the SQL Server specific forums: http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19&SiteID=1 


Kapil

Answer 2

Thanks kapil for proivding help but your link dosent work and show me error "Page Not found".

Answer 3

please try again  this link is working