Script voor activeren van VOIP

-- aanmaken Skype belacties
SET NOCOUNT ON;

DECLARE @myTrip int;
DECLARE @pla_telefoon VARCHAR(20);

DECLARE MyCursor CURSOR FOR
select DISTINCT pla_id
from planning
inner join ritstaten on lsn_id = pla_lsn
inner join wagens on wag_id = lsn_wag_id
where pla_status = 'T'
and pla_soortrit = 'S'
and (pla_oph_latitude > 0)
and (pla_oph_longitude > 0)
and (pla_klant_email = 0)
and (len(pla_telefoon) > 0)
and convert(date, pla_datumtijd) = convert(date, getdate())
and (pla_filter IN ('B', 'P', 'T') OR (pla_soortvervoer = 'Z'))
and (DATEDIFF(minute, getdate(), pla_eta) <= 10)
and (isnull(pla_ETA_klok,0) <> 0)

OPEN myCursor

FETCH NEXT FROM myCursor
INTO  @myTrip
WHILE @@FETCH_STATUS = 0
BEGIN
   -- verwerken
   -- print @myTrip;
   select @pla_telefoon = pla_telefoon from planning WHERE pla_id = @myTrip;
   insert into Skype (SkypeDate, SkypeNumber, SkypeRitnummer, SkypeStatus) values (getdate(), @pla_telefoon, @myTrip, 1);
   update planning set pla_bellen = 1, pla_klant_email = 1 where pla_id = @myTrip;
   -- einde verwerken
  FETCH NEXT FROM MyCursor INTO  @myTrip
END
CLOSE MyCursor
DEALLOCATE MyCursor;