Which is best use for Where condition or cursor ?

Question

1.00/5 (1 vote)

See more:

I am manage all record by id. Add Record in column in table only product Id with separate comma.
Expamle

ProductId:-
15,11,16,22,21,8,13,1,12,7,9,19,4

Searching for record which is best Where condition or cursor ?

Suggest me

Brijesh Kumar
~~*********~~

[Edit]: Removed Mobile number

Posted 10-Jun-14 1:55am

Brijesh Kumar Prajapati

Updated 10-Jun-14 2:55am

Nirav Prabtani

v2

Add a Solution

Comments

CHill60 10-Jun-14 8:04am

Is that a list of ids in your table? Where are the commas coming from?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-06-10T02:54:00

Don't.
storing commas separated strings of ids is a bad idea: it makes them a nightmare to use as SQL is not good at string manipulations.

Have separate table which "links" the records: the id of the row you want to associate with the id list, and the id you want to associate it with. So for your string, you would have 13 rows in the association table. It may seem like hard work, but think about it: which is easiest:
1) Removing id "21" from your string without affecting anythign else
Or
2) This:

SQL

DELETE FROM AssociationTable WHERE BaseId=1 AND AssocId = 21