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 |
|
danielhai
Yak Posting Veteran
50 Posts |
 Posted - 2002-06-24 : 19:01:59
|
| I have a contacts management system where currently the contact groupings are static, as in, there is a table that associates lists to the contacts. I now want to change the lists into dynamic lists, so lists don't have to be updated all the time.(The lists are generated by search queries).Does anyone know of any places that have structures set up to create dynamic lists? I was thinking about creating views to parse the logic, but it doesn't take parameters? Anyone have any ideas? |
|
|
vladimir_grigoro
Yak Posting Veteran
62 Posts |
Posted - 2002-06-25 : 08:25:47
|
| Hi.I just need more details. What you mean by dynamic lists?The Rebel |
 |
|
|
danielhai
Yak Posting Veteran
50 Posts |
Posted - 2002-06-25 : 14:37:46
|
I think it'd be easier to explain with an example(i know that was pretty vague)ContactContactID FirstName LastName SomeID Extra--------- --------- -------- ------ -----1 Joe Shmoe 1 22 Jane Shmoe 1 33 George Harrison 2 34 Bob Dole 3 55 Annie Person 3 56 Joel Noes 3 17 Doug Scrambler 4 18 Happy Daze 5 29 Han Solo 5 110 John Smith 5 3ListMemberListMemberID ListID MemberID------------ ------ --------1 1 12 1 23 1 54 1 75 1 96 2 37 2 48 2 8 I have a search page where users can be searched on, and lists are generated based on those queries - for example: You can search on GroupID, and then add users to a list(ListMember table). Problem is, there are new users registering all the time, and as the list is static, new users that meet the criteria of the first query are not being added. I was wondering if anyone knew of a good system to make these dynamic lists.I do have a filtering system in place, but it uses server code along with SQL - I was looking for a purely SQL way to do this. I'm working on a way to do it using dynamic SQL, but I don't know how fast it will be, since there are a lot of search options ...thanks in advance |
|
|
|
|
|
|
|
|
Dynamic Lists