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 - 2000-12-30 : 11:03:58
|
Karl writes "How can I put an always changing array into a stored procedure?
e.g.
table 1:
clubid memberid
2 55
2 58
2 52
table 2:
company name userid
dsdfsdf 2
sfsdfsfd 10
sdfsdf 55
sfsdf 52
sdfsdf 58
sfsdfsdf 111
fsdfsf 459
So, now i want to select all the company names with userid that is NOT in table 1. ---> 2, 10, 111 and 459
But the next time I visit the page, it is possible that e.g. number 111 is also in table 1.
How do I solve this tricky bit of sql?" |
|
|
|
|
|
Array