My SQL syntax so far is as follows:
Select NodeID, Event_Time, Group_Status_Icon, NodeName, EventTypeIcon, Cast(Message As nvarchar(250)) as Message From ( SELECT Nodes.NodeID AS NodeID,
Events.EventTime AS Event_Time,
Nodes.GroupStatus AS Group_Status_Icon,
Nodes.Caption AS NodeName,
(...