E164-Anbieter

rem --------------------------------------------------------
rem Group1 aktualisieren, Stammzone
rem Group2 aktualisieren
rem PrefixName aktualisieren (verwendet im EVN !!!)
rem --------------------------------------------------------
cd ../trunk/Bin/Debug

Billing.JobHost.exe SqlCommand "UPDATE ResourceUsageRecord SET Group1 = (SELECT TOP (1) InhZone AS Expr1 FROM E164PrefixView AS T2 WHERE (SUBSTRING(ResourceUsageRecord.Destination, 1, { fn LENGTH(DialPrefixId) }) = DialPrefixId) ORDER BY DialPrefixId DESC) WHERE (Group1 IS NULL) AND (Destination IS NOT NULL) AND (Time > DATEADD(hour, - 48, { fn NOW() }))"

Billing.JobHost.exe SqlCommand "UPDATE ResourceUsageRecord SET Group2 = (SELECT TOP (1) InhType AS Expr1 FROM E164PrefixView AS T2 WHERE (SUBSTRING(ResourceUsageRecord.Destination, 1, { fn LENGTH(DialPrefixId) }) = DialPrefixId) ORDER BY DialPrefixId DESC) WHERE Group2 IS NULL AND ResourceUsageRecord.Destination IS NOT null and carrier IS NOT null AND (Time > DATEADD(hour, - 48, { fn NOW() }))"

Billing.JobHost.exe SqlCommand "UPDATE ResourceUsageRecord SET Zone = (SELECT TOP (1) LEFT(InhZone + ' ' + REPLACE(DialPrefixName, 'Germany ', ''), 50) AS Expr1 FROM E164PrefixView AS T2 WHERE (SUBSTRING(ResourceUsageRecord.Destination, 1, { fn LENGTH(DialPrefixId) }) = DialPrefixId) ORDER BY DialPrefixId DESC) WHERE (Zone IS NULL) AND (Destination IS NOT NULL) AND (Time > DATEADD(hour, - 48, { fn NOW() }))"