Справочник Пользователя для Intellisense Sdn Bhd 2401T200
Setup Guide for System Integrator
Page 18 of 19
Free Alliance Sdn Bhd.
Confidential and Proprietary
2.3.12 In this section, user will perform few simple SQL Statements to insert the node
data.
NB: This step shall be performed every time user redoes the site survey.
2.3.13 Execute SQL script to delete the OLD data as shown below.
Delete from fasb_MapsNodesRelativedZone
2.3.14 Execute below SQL script to select the Map ID.
Select ID from fasb_Maps
2.3.15 Note down the ID value which will be used on the following steps. Value is integer
type.
2.3.16 Replace the Map ID Value (value
11
as highlighted in red below) with the noted ID
value on the following statement below.
INSERT INTO fasb_MapsNodesRelativedZone
(MapID,MapNodeID,ZoneID,ZonePriority,Created,Modified)
SELECT
11
,MapNodeID,AccessPointID,row AS
ZonePriority,GETDATE(),GETDATE() FROM (
SELECT row_number() over (partition by MapNodeID order by
MapNodeID,RSSI desc) as row,
MapNodeID,
AccessPointID,
RSSI
FROM fasb_RSSIMatrix WHERE TagApplicationID=8) AS tbl1
MapNodeID,RSSI desc) as row,
MapNodeID,
AccessPointID,
RSSI
FROM fasb_RSSIMatrix WHERE TagApplicationID=8) AS tbl1
2.3.17 Execute above SQL script to insert the data.
2.3.18 Exit Microsoft SQL Server 2008.