Alastair That is what I am wanting to do,
Thanks Marc From: Alastair Burr Sent: Thursday, June 25, 2009 1:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Small Brain twister ... at least for me Marc, Are you trying to create one row in your new table for each each day with the varchar column containing 2, or more, rows/values from the original table? If so, you probably need to insert the first row for each day first and then update the varchar column with the additional values: INSERT INTO newtable SELECT ... FROM oldtable WHERE DAY = [date] AND rownumber = 1 SELECT varchar INTO newvalue FROM oldtable WHERE DAY = [date] AND rownumber = 2 -- repeat for row 3, etc. UPDATE newtable SET varchar = (varchar & .newvalue) WHERE DAY = [date] Of course, I may have totally misunderstood your requirement and others may have better ways... Regards, Alastair. ----- Original Message ----- From: MDRD To: RBASE-L Mailing List Sent: Wednesday, June 24, 2009 11:14 PM Subject: [RBASE-L] - Small Brain twister ... at least for me Hi I have a table with custnum, TrDate, Notefield, Vernumber. There may be more that 1 row per day but the Vernumber is an autonumber field and should have a bigger number for the second note for the day. I want to Insert the rows into a new Table using a Varchar field. I want to have a PK on custnum and the date in the new table. This is easy but I want to add the second row for the day to the bottom of the Varchar field for the days with 2 rows. This is where my brain starts to twist. I can think of clunky ways of doing this but I am sure there are better ways than what I an thinking of? Is there a simple way to do this or do I just clunk along? Thanks Marc ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.374 / Virus Database: 270.12.90/2198 - Release Date: 06/23/09 17:54:00
