create proc noteges.GetEstanciasByLang
(
	@ViviendaId int
	,@estancia int
	,@Lang char(3)
)
as
	create table #temp(Id int identity(1,1),Lang varchar(250))
	declare @columna char(10)
	declare @sql varchar(250)
	declare @cadena varchar(500)
	declare @result varchar(500)
	set @columna = 'Idioma' + @Lang
	set @sql = 'select '+ @columna + 'from noteges.t_viviendadatos D join tablas.t_parametros P on D.ParametroHijoId = P.ParametroId where viviendaid = ' + cast(@ViviendaId as char(5)) + 'and estanciaid = '+ cast(@estancia as char(5)) + 'order by idiomaesp desc'
	insert into #temp exec(@sql)
	DECLARE @miVar varchar(max)
	SET @miVar = ''
	SELECT @miVar = @miVar + ',' + Lang FROM #temp
	drop table #temp
	select @miVar