Re: Help with Stored proceedure

anonymous_at_discussions.microsoft.com
Date: 09/25/04 

Date: Sat, 25 Sep 2004 04:44:25 -0700

Thanks David,
No, I can't pass in the variname only the langid, so
somehow I need to embed the variname's to be returned in
the SP, say:-
'strlabel1'
'strlabel2'
'strlabel3'
'strlabel4'
but also when I map the SP from Crystal reports I need to
see the return value's so I can use them as labels in
different parts of the report, as you would see with
Select worda, wordb,wordc etc.

Cheers

>-----Original Message-----
>CREATE PROCEDURE usp_languagewords (@langid INTEGER,
@variname VARCHAR(50))
> AS
> SELECT word
> FROM languagewords
> WHERE langid = @langid
> AND variname = @variname
>
>GO
>
>EXEC usp_languagewords
> @langid = 1,
> @variname = 'strlabel1'
>
>Is this what you want?
>
>--
>David Portas
>SQL Server MVP
>--
>
>
>.
>

Loading