I am inserting the multiple values in the database for a particular user, but now i want to insert the splitted values with that username.
eg,
user name areas
abc 10,14,15

Now i want to store in other table as
user name areas
abc 10
abc 14
abc 15


Please reply as soon as possible.

Hi there,

If you don't use any client applications that could do this in much easier ways for you, then you will have to write a procedure/function that could do this for you in your Database.

I am not sure if you are trying to do this from a client-side application or on the SQL server directly. Let me know on this.

Cheers!

_________________________
- Vijay G
Strive for Perfection

If you are using a web technology then you can change it by using any client side scripting

Numan
--------------------------------------------------
Love is the most precious thing of this world. So find and grab it!

I do something similiar to this all the time.

<%
Dim strAreas
Dim aryNumbers
Dim strUser

strUser = "abc"
strAreas="10,14,15"
aryNumbers = Split(strAreas, ",")

for i = 0 to UBound(aryNumbers)

    strSQL = "INSERT INTO YourDataBase (Username, Areas) " &_
            "VALUES ('" & strUser & "', '" & aryNumbers(i) & "');"
    objConn.Execute(strSQL)

    Response.Write(strUser & " - " & aryNumbers(i) & "----Was Inserted<BR>")
next
%>