Help with Stored Proceedure

[Billy991]

I have limited knowledge of sql quiries and am trying to
do the following:-
I have a langage table with cols
langID : VariName : word
I need to create a stored procedure which I only pass in
the langID as Int but this will select numerous word
matching a pre defined list of VariName (i.e.
strlabel1,strlabel2,strlabel3)
I have tried
select word from languagewords
where
landID = 1
and
VariName = 'strlabel1'
--------------------
My problem is that I need to see a multiple select
statement so that when I map this SP from Crystal reports
it will show all the returns so I can map to different
parts of the report
.

 

[donutman]

Your question isn't clear. Maybe example row data and the appearance of desired report would help.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[Billy991]

Thankyou for you response,
I have now found a solution.
Regards