Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Brain dead - SQL syntax
Message
De
07/09/2007 16:09:55
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01253096
Message ID:
01253121
Vues:
22
>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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform