Thanks again. From my ASP page it's easier for me to pass comma-delimited list. But I would use this advise later on.

The procedure is working fine now. I would need to call it from ASP page.

>If fn_split is a table-valued function, you would use this:
>
>INSERT INTO cartDetail (...)
>SELECT columnlist FROM dbo.fn_split()
>
>I perfer to pass an XML fragment into the stored procedure instead of a string that contains comma-delimited items.
>
>-Mike