declare @NET_ID uniqueidentifier
	, @Id uniqueidentifier
	, @Name nvarchar(max)
	, @Tech nvarchar(max)
	, @NetID uniqueidentifier
	, @MAC nvarchar(max)
	, @IP nvarchar(max)
	, @Site nvarchar(max)

declare APCur Cursor Fast_Forward
	for select * from [192.168.3.44].[teledataict_08].dbo.vwMigAPs


set @NET_ID = '4586612A-CCED-4EAC-A46D-509AACB36953'

open APCur

fetch next from APCur
	into @Name, @Tech, @MAC, @IP, @Site

while @@FETCH_STATUS = 0
begin

	select @NetID = Id
	from NETWORK
	where NAME like '%' + @Tech + '%'

	exec spACCESSPOINT_Update @Id, null, null, null, null, @Name, 0, 14, 14, @Name, '0.0', @MAC, @IP, @NetId

	fetch next from APCur
		into @Name, @Tech, @MAC, @IP, @Site

end

close APCur
deallocate APCur