Hi
I'm using MSSQL7 and want to write a stored procedure that generates a
SELECT statement returning a single value to a variable.
Example :
CREATE PROCEDURE Sample
@par varchar(255),
@hours int OUTPUT
AS
DECLARE @var int,
@where varchar(255)
SET @where = ' WHERE UserID = ' + @par
EXECUTE('SELECT @var = SUM(Hours) FROM Staff' + @where)
SET @hours = @var
This fails as @var is not recognised.
How can I return a value from the EXECUTE statement?
TIA
Stephen
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
