Hi,
The input parameter for the stored procedure is a collection. Without using loops how the iteration can be done. I think inspite of using loop i can get the records at one sort by using "IN". But in the where condition the left parameter is the number, how this collection can be compared with that. Should i use arrays? or is there any way i can achieve this?

Thanks,
Jaya

Hi Jaya, welcome to DaniWeb.

You have posted in the wrong forum I am afraid, this is for introducing yourself to the community only, not asking questions.

Might I suggest that you browse the forum categories and find the one most suited to your question and repost. You will stand a much better chance of getting the help you are looking for that way.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.