General information
Category:
Coding, syntax & commands
Title:
SQL to normalize a denormalized table?
Is there a way to get from this:
datapoints(timestamp, pointcount, pointvalues)
note - point values is binary data where there are pointcount points packed into a character field (pointvalue x is at character position x*sizeof(pointvalue)).
to:
datapoints(timestamp, pointnumber, pointvalue)
Where there is on record per point for a given timestamp.
The solution must be a single SQL statement and the statement cannot be dynamically generated.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only