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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Storing and processing arrays in sql

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-08 : 07:52:38
Newbie writes "Please direct me where to look for simple articles on how to store arrays in sql with the benefits and pitfalls of each method.
The data is not uniform it can be
a. a list of possible codes where one code is required.
b. multiple lists of possible codes where one code from either list is required. (list a and list b)
c. multiple lists where one code from each list is required.(list a or list b)
d. combination of b and c (list a and list b or list c and list d)
A list of codes have to be verified against these options.
Is there a sample of a query or proc that uses a list as input to check against lists?"
   

- Advertisement -