Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL to normalize a denormalized table?
Message
From
25/11/1998 00:20:25
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL to normalize a denormalized table?
Miscellaneous
Thread ID:
00161242
Message ID:
00161242
Views:
52
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
Map
View

Click here to load this message in the networking platform