I have a SQL server 7.0 problems and I need a script that can go through a column in a table to find specific piece of data and update another table with that data
TABLEA may contain multiple entries for the Notes Field. So for each entry I want to
Search each of the entries
TABLEA (AccountNo, Notes)
*** JULIES *** July 4, 2001 at 11:27am
Siva faxed required delivery schedule. first delivery 23rd July for 24 of
*** JULIES *** June 22, 2001 at 4:22pm
Siva called me back to tell me he needs 4 of the same spec as 458882 now and that they will be
The NOTES field has multiple entries at different date and time.
From the information in the “Notes” . Extract the details there and place the relevant details into “history” TABLEB using the Date separator as a record separator, the first 30 characters as the “Reference” and the whole note as the “Notes” data ie records that look like…
*** JULIES *** July 4, 2001 at 11:27am
Siva faxed required delivery schedule. first delivery 23rd July for 24 of
Should end up as history items with the following format…
TABLEB (AccountNo Date, User, Reference, Notes)
DATE: July 4, 2001 at 11:27am
User: *** JULIES ***
REFERENCE: Siva faxed required delivery (30 char of the notes field)
NOTES: Siva faxed required delivery schedule. first delivery 23rd July for 24 of
I really hope this make sense.