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
If it's not broken, fix it until it is.
My Blog