Re: Help with Stored proceedure

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 09/25/04

Next message: Roji. P. Thomas: "Re: Insert Query taking ages...."
Previous message: Kan Grewal: "Re: Insert Query taking ages...."
In reply to: Phil: "Help with Stored proceedure"
Next in thread: anonymous_at_discussions.microsoft.com: "Re: Help with Stored proceedure"
Reply: anonymous_at_discussions.microsoft.com: "Re: Help with Stored proceedure"
Messages sorted by: [ date ] [ thread ]

Date: Sat, 25 Sep 2004 12:32:50 +0100

CREATE PROCEDURE usp_languagewords (@langid INTEGER, @variname VARCHAR(50))
AS
SELECT word
  FROM languagewords
  WHERE langid = @langid
   AND variname = @variname

EXEC usp_languagewords
@langid = 1,
@variname = 'strlabel1'

Is this what you want?

-- 
David Portas
SQL Server MVP
--

Next message: Roji. P. Thomas: "Re: Insert Query taking ages...."
Previous message: Kan Grewal: "Re: Insert Query taking ages...."
In reply to: Phil: "Help with Stored proceedure"
Next in thread: anonymous_at_discussions.microsoft.com: "Re: Help with Stored proceedure"
Reply: anonymous_at_discussions.microsoft.com: "Re: Help with Stored proceedure"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Help with Stored proceedure
... the langID as Int but this will select numerous word ... matching a pre defined list of VariName (i.e. ... statement so that when I map this SP from Crystal reports ...
(microsoft.public.sqlserver.programming)
Re: Help with Stored proceedure
... (@langid INTEGER) ... FROM languagewords ... SQL Server MVP ...
(microsoft.public.sqlserver.programming)