Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Brain dead - SQL syntax
Message
 
 
À
07/09/2007 15:13:43
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:
01253098
Vues:
18
How the parameter is related to the data in the tables?

>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?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform