Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Divide single to 10 columns
Message
From
04/03/2014 06:04:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Divide single to 10 columns
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01595719
Message ID:
01595719
Views:
58
Sir,

I have following data

createcursor no (no i)
insertinto no values (1045)
insertinto no values (1057)
insertinto no values (1582)
insertinto no values (100595)
insertinto no values (138143)
insertinto no values (200129)
insertinto no values (400290)
insertinto no values (500692)
insertinto no values (526834)
insertinto no values (604796)
insertinto no values (636867)
insertinto no values (650205)
insertinto no values (702060)
insertinto no values (828486)
insertinto no values (900428)
insertinto no values (915414)
insertinto no values (971656)
insertinto no values (998987)

Table has only one fixed length column as n(6).

I want to get this result:
Attachment: Image1

and data range in columns is as under:
Attachment: Image2

Please help me
Next
Reply
Map
View

Click here to load this message in the networking platform