How split delimiters and get the values

[Guvera]

Hi,

I am using sql server 2005. A parameters coming to sp like that

aggr | view&true,edit&true | package | view *true,edit&false,delete&true

this parameters are coming from my front end. I need to split this parameters and need to get like that

featurename operation status

========= ======== =====

aggr view true

edit true



and also package like above in array and i get these values every time and insert to table.



Is it possible. Its very urgent. Please suggest me.Hope yours reply

Thanks

[RunsWithScissors]

Can you give us a little more information?

I am having a little trouble understanding, but:

You should REALLY design your SPROC with distinct parameters for each value you want to insert. Myabe I am misunderstanding, but unless it is just not possible, it makes no sense to me to pass a concatenated parameter into a Stored Procedure, which then needs to be dissembled before INSERT.

Could you post the code for the sproc, as well as the front end code whcih is trying to use the sproc?