Re: Multiple datasets in one dataset

From: <roman.morokutti_at_googlemail.com>
Date: Tue, 16 Oct 2007 01:48:26 -0700
Message-ID: <1192524506.679904.140760@q3g2000prf.googlegroups.com>

Hi Brian,

> 1) TABLE Foo records the progress of a piece through a machine. Yes.
> 2) It has up to six stages.
Yes.
> 3) Each stage has 10 values.
Yes.
> 4) A unique piece is identified by WP and Curr_MS. Yes.
> 5) Different stages are identified by Value_Group. Yes.
> 6) The requirement is to get the current stages of a given piece. Yes.
> 7) An INNER JOIN query was written to retrieve the data in one record. Yes.
> 8) The query only returned data for pieces that completed all stages. Yes.

>
> If that is the case, the solution would be to change the INNER JOIN to
> an OUTER JOIN. That would not restrict the data returned to having all
> stages with data.
>
> B.

But how to make such a query? I have no clue. Maybe you could test your
thoughts and post it here with this data. Thanks for your help.

Sample data:

REM INSERTING into foo
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27715049,999,1255,1255,47,46,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27719532,999,1255,1255,47,46,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27724500,999,1255,1255,47,46,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27729769,999,1255,1255,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27734812,999,1255,1255,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27740025,999,1255,1255,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27745210,999,1255,1255,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27750335,999,1255,1255,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27755360,1025,1281,1280,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27760425,1066,1322,1309,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27765464,1076,1332,1324,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27770281,1115,1115,1107,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27775205,1147,1147,1140,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27780115,1193,1193,1182,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27784977,1238,1238,1225,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27789859,1261,1261,1249,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27794742,1269,1269,1262,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27799624,1280,1280,1275,47,0,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27804331,1271,1271,1262,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27809138,1255,1255,1253,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27814001,1259,1259,1253,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27818811,1268,1268,1262,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27823695,1257,1257,1250,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27828487,1258,1258,1248,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27833314,1257,1257,1252,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27838168,1261,1261,1250,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27842974,1267,1267,1257,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27847875,1247,1247,1242,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27852823,1260,1260,1252,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27857611,1254,1254,1246,47,49,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27862504,1246,1246,1244,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27867452,1248,1248,1241,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27872342,1262,1262,1257,47,49,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27877131,1252,1252,1247,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27882102,1267,1267,1258,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27886896,1252,1252,1247,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27891697,1263,1263,1259,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27896561,1266,1266,1262,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27901301,1270,1270,1262,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27906003,1265,1265,1259,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27910907,1271,1271,1259,47,46,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27915709,1263,1263,1258,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27920506,1261,1261,1254,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27925300,1265,1265,1256,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27930001,1258,1258,1252,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27934902,1261,1261,1250,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27939524,1259,1259,1254,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27944163,1255,1255,1251,47,46,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27944163,1255,1255,1251,8,46,1,6432,0,1,1); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27944163,9987,9987,39,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27944163,1688,429,33,65397,65405,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27944163,15,304,355,444,483,538,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27944163,480,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27948982,1262,1262,1258,47,46,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27948982,1262,1262,1258,8,46,6,2336,0,1,1); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27948982,9993,9987,39,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27948982,1660,417,22,65392,65413,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27948982,15,308,356,446,492,522,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27948982,482,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27953843,1260,1260,1254,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27953843,1260,1260,1254,8,46,11,2336,0,2,2); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27953843,10003,9993,24,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27953843,1686,433,42,65395,65409,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27953843,15,303,355,439,500,520,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27953843,484,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27958662,1266,1266,1257,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27958662,1266,1266,1257,8,46,15,2336,0,3,3); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27958662,10012,10003,9,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27958662,1691,427,30,65407,65419,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27958662,15,300,356,445,463,507,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27958662,484,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27963529,1269,1269,1261,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27963529,1269,1269,1261,8,46,20,2336,0,4,4); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27963529,10019,10012,65530,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27963529,1676,431,32,65417,65420,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27963529,15,301,352,442,441,506,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27963529,478,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27968330,1256,1256,1254,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27968330,1256,1256,1254,8,46,25,6432,0,5,5); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27968330,10023,10019,65515,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27968330,1680,444,38,65402,65406,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27968330,10,300,350,441,477,522,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27968330,477,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27973125,1261,1261,1256,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27973125,1261,1261,1256,8,46,30,2336,0,6,6); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27973125,10026,10023,65500,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27973125,1674,435,37,65390,65411,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27973125,10,303,352,440,502,520,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27973125,481,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27977941,1265,1265,1258,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27977941,1265,1265,1258,8,46,34,2336,0,6,6); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27977941,10029,10026,65485,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27977941,1671,437,31,65391,65409,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27977941,10,302,350,448,501,516,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27977941,483,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27982651,1263,1263,1255,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27982651,1263,1263,1255,8,46,39,6432,0,6,6); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27982651,10031,10029,65470,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27982651,1687,434,38,65402,65406,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27982651,10,300,353,439,478,528,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27982651,483,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27987372,1267,1267,1261,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27987372,1267,1267,1261,8,46,44,6432,0,6,6); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27987372,10032,10031,65455,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27987372,1674,436,38,65401,65406,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27987372,10,303,351,439,478,522,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27987372,482,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27992172,1265,1265,1259,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27992172,1265,1265,1259,8,46,50,6400,0,6,6); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27992172,10033,10032,65440,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27992172,1674,423,41,65404,65403,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27992172,0,302,358,435,478,530,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27992172,481,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,27996903,1265,1265,1259,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,27996903,1265,1265,1259,8,46,54,6400,0,6,6); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,27996903,10034,10033,65425,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,27996903,1696,441,38,65402,65408,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,27996903,0,299,350,442,480,529,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,27996903,480,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,28001710,1270,1270,1266,47,47,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,28001710,1270,1270,1266,8,46,59,6400,0,6,6); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,28001710,10037,10034,65410,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,28001710,1676,438,40,65402,65404,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,28001710,0,302,351,441,478,526,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,28001710,478,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,28006415,1262,1262,1255,47,48,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,28006415,1262,1262,1255,8,47,4,14592,0,6,6); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,28006415,10038,10037,65395,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,28006415,1700,435,24,65400,65410,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',24,28006415,0,300,357,455,472,517,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',25,28006415,478,0,0,0,0,0,0,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',11,28011080,1260,1260,1256,47,46,1242,1290,0,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',21,28011080,1260,1260,1256,8,47,9,14592,0,6,6); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',22,28011080,10039,10038,65380,300,350,440,480,500,0,0); Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VALUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALUE_10)
values ('418',23,28011080,1682,448,49,65407,65407,0,0,0,0,0);

Regards
Roman Received on Tue Oct 16 2007 - 03:48:26 CDT