Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Brain dead - SQL syntax
Message
From
07/09/2007 16:09:55
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01253096
Message ID:
01253121
Views:
23
>How the parameter is related to the data in the tables?

They are comma delimited lists of either must be qualifiers or must not be qualifiers.


>
>>I just can't figure this one out! I have the following tables:
>>
>>Contacts
>> id int,
>> lastname varchar(255),
>> ...
>>
>>qualifier
>> id int,
>> description varchar(255),
>> ...
>>
>>ContactQualities
>> contactid int,
>> qualifierid int,
>> ...
>>
>>I need to formulate a SQL stored procedure which will produce a cursor of contacts which have a list of qualities.
>>
>>parameter looks like this
>> '01,05...'
>>
>>Any suggestions?
Previous
Reply
Map
View

Click here to load this message in the networking platform