set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER Procedure [dbo].[GNN_TecnicosPorUnidadGet]
(
	@idUnidad int
)

as

declare @ret varchar(4000)
set @ret = ''
declare cur cursor

for

select t.NombreTecnico
from GNN_TecnicosPorComercial t

inner join vw_aspnet_MembershipUsers m
On t.NombreTecnico = m.UserName
And IsLockedOut = 0

inner join GNN_ComercialPorUnidad c
on t.NombreComercial = c.NombreComercial
and c.IdUnidad = @idUnidad

declare @tecnico varchar(100)
open cur

fetch next from cur into @tecnico
while (@@fetch_status != -1)
begin
	set @ret = @ret + '{' + @tecnico + '}'
	fetch next from cur into @tecnico
end
close cur
deallocate cur

select @ret as Tecnicos