Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-20 : 08:17:52
|
| gaurav writes "I need to compare 2 csv(comma seperated) strings of IDs stored on two different tables so as to check whether the specified IDs present in the string(csv string 1) is there in another string (csv string 2) of IDs." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-20 : 09:06:56
|
| Search for where in @MyCSV in this topichttp://sqlteam.com/forums/topic.asp?TOPIC_ID=55210 Also you should not store csv values in the column. Instead, store each value in each rowMadhivananFailing to plan is Planning to fail |
 |
|
|
CactusJuice
Starting Member
46 Posts |
Posted - 2006-06-06 : 17:54:22
|
Why not? For example, I want to record which search options a visitor is using. I might have several multi-select List boxes, check box lists, etc. One list box might have three options chosen and another five. Storing in CSV seems to be the best way, no?quote:
Originally posted by madhivananAlso you should not store csv values in the column. Instead, store each value in each row
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-06 : 17:56:32
|
quote:
Storing in CSV seems to be the best way, no?
It certainly isn't the best way to store things in the database. So is the data really stored like this in the table or is this CSV string coming from the client?Tara Kizeraka tduggan |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-06-07 : 01:58:57
|
quote:
Originally posted by CactusJuice
Why not? For example, I want to record which search options a visitor is using. I might have several multi-select List boxes, check box lists, etc. One list box might have three options chosen and another five. Storing in CSV seems to be the best way, no?quote:
Originally posted by madhivananAlso you should not store csv values in the column. Instead, store each value in each row
Read about Normalisationhttp://www.datamodel.org/NormalizationRules.htmlMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
two csv string comparisons