SQLug 2014 Challenge Main

set nocount on;

-- Load Prislista to PrislistaMem
insert into dbo.PrislistaMem(Taxekod, Pris)
select Taxekod, Pris
from dbo.Prislista;

-- Remove all rows from Ersattning
truncate table dbo.Ersattning;

-- Send messages to target
declare @NumMsgs int;
exec dbo.SendMsg @NumMsgs out;

-- Relase the queuereaders
delete from dbo.StartIt;

-- Receive replies
exec dbo.ReceiveMsg @NumMsgs;