Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JJ297
Aged Yak Warrior
940 Posts |
 Posted - 2010-03-19 : 14:40:32
|
How could I enter this data in a table so I can run queries to obtain the following information? What would my column headings(fields) be?This is what I want to sort by:All MOD1, MOD2 etc, PA1 000 thru 363PA2 363 thru 727PA3 727 thru 999Here's the data:PA1 000 THRU 363 MOD 1 000 THRU 090 MOD 2 091 THRU 1817 MOD 3 1818 THRU 272 MOD 4 273 THRU 363PA2 364 THRU 727 MOD 5 363 THRU 454 MOD 6 455 THRU 545 MOD 7 546 THRU 636 MOD 8 637 THRU 727PA3 728 THRU 999 MOD 9 727 THRU 818 MOD 10 819 THRU 908 MOD 11 910 THRU 999 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-20 : 01:09:28
|
| is this how data resides in table? may be you could explain us table structure along with how it holds data------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Setting up a table