Hi,
I've been asked to extract data from a datadase in the following format.....
The above is only a demo of the data but the basic format should be the same. Is this a standard convension and how do you write the SQL to enter the "$1" type record identifiers and produce the multiple product records ($2) for the one customer records($1).
I've been asked to extract data from a datadase in the following format.....
Code:
&0,"REPORT","2","0"
&1,"ID","SURNAME","FORENAME","ADDRESS_1"
&2,"PROD ID","TEXT","VALUE1"
$1,"1","BECKLES","DAVID","75 FIR TREE APPROACH"
$2,"19990830","Sample product 1","90"
$2,"20030202","Sample product 2","95"
$2,"20031216","Sample product 3","101"
$1,"3","WRIGHT","DONNA","88 POTTERTON LANE"
$2,"19841205","Sample product 3","101"
$2,"20030914","Sample product 1","90"The above is only a demo of the data but the basic format should be the same. Is this a standard convension and how do you write the SQL to enter the "$1" type record identifiers and produce the multiple product records ($2) for the one customer records($1).