-------3
WeatherData
City
nvarchar(35)
not null
Date
datetime
not null
Low
float
not null
High
float
not null
Forecast
nvarchar(3500)
not null
CREATE INDEX myIndex
ON WeatherData ( City );
-----4
WeatherAlerts
City
nvarchar(35)
Date
datetime
Low
float
High
float
Forecast
nvarchar(3500)
XsltFormatter
XsltBaseDirectoryPath
%_AppPath_%
XsltFileName
WeatherTransform.xslt
File
------5 a
INSERT INTO WeatherAlerts(SubscriberId,
DeviceName, SubscriberLocale, City, Date, Low, High,
Forecast)
SELECT s.SubscriberId, s.DeviceName, s.SubscriberLocale,
e.City, e.Date, e.Low, e.High, e.Forecast
FROM WeatherData e, WeatherCity s
WHERE e.City = s.City;
---5 b
WeatherCity
DeviceName
nvarchar(255)
not null
SubscriberLocale
nvarchar(10)
not null
City
nvarchar(40)
not null
WeatherEventRule
WeatherData
INSERT INTO WeatherAlerts(SubscriberId,
DeviceName, SubscriberLocale, City, Date, Low, High,
Forecast)
SELECT s.SubscriberId, s.DeviceName, s.SubscriberLocale,
e.City, e.Date, e.Low, e.High, e.Forecast
FROM WeatherData e, WeatherCity s
WHERE e.City = s.City;
--6
WeatherSPEventProvider
--7
PT15S
--8
PT15S
false
false
false
P1D
23:00:00
P0DT02H00M00S