|
Hi all,
I have a data entry form which will capture some customer information and product information.
I would be using a store procedure to save the information into the 2 separate table. However, the product information is pass in as a delimited string, e.g. 'Product A, Product B, Product C'.
I would like to split the string and save it into a table with structure like
CustomerID, ProductName, meaning the table will need to save 3 rows of data.
My company is now using MSSQL7, thus I not sure if we can use any user define function. Please advise.
|
