SELECT     dbo.Item.IField, dbo.Item.IValue
FROM         dbo.Item RIGHT OUTER JOIN
                      dbo.Report ON dbo.Item.ReportID = dbo.Report.ID
WHERE     (dbo.Report.RHost = 'URAN')
GROUP BY dbo.Item.IValue, dbo.Item.IField
HAVING      (dbo.Item.IField = 'DNS')

if OBJECT_ID('tempdb..#tbl') is not null
	drop table #tbl

create table #tbl (good varchar(100),price money, PriceDate date) 

insert into #tbl values ('pepsi',50,'20130516'), ('coca-cola',52,'20130516'),('pepsi',50,'20130514'), ('coca-cola',52,'20130514')


declare @sql varchar(max)
declare @select_list varchar(max)

select @select_list=ISNULL(@select_list+',','')+'['+good+']' from #tbl group by good order by good


	SET @sql =
	'SELECT PriceDate, ' + @select_list + '
	 FROM (SELECT PriceDate, price, good 
		  FROM #tbl TS) TS
	 PIVOT (
			AVG([Price])
			FOR good IN (' + @select_list + ')
			) AS pvt
	ORDER BY pvt.PriceDate
	'

exec (@sql)