returning an interger 1

[copeZero]

Hi i can't seem to get a value from this, any suggestions


DECLARE @Random int;
DECLARE @Upper int;
DECLARE @Lower int

SET @Lower = 100
SET @Upper = 150
SELECT @Random = Round(((@Upper - @Lower -1) * Rand() + @Lower), 0)

RETURN
GO

 

[SQLDenis]

DECLARE @Random int;
DECLARE @Upper int;
DECLARE @Lower int

SET @Lower = 100
SET @Upper = 150
SELECT @Random = Round(((@Upper - @Lower -1) * Rand() + @Lower), 0)
SELECT @Random

or inside a proc if you want to use the return statement

DECLARE @Random int;
DECLARE @Upper int;
DECLARE @Lower int

SET @Lower = 100
SET @Upper = 150
SELECT @Random = Round(((@Upper - @Lower -1) * Rand() + @Lower), 0)
RETURN @Random

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[copeZero]

tried the proc method, actually tried it prior to posting here. no luck with it. this is the actual proc:

CREATE PROCEDURE dbo.sp_Temp2
(
@pass nvarchar(40),
@ques nvarchar(100),
@MID int,
@answ nvarchar(80)
)
AS
SET NOCOUNT ON

UPDATE [_Info] SET isTemp=0, pw=@pass, sQ=@ques, sA=@answ 
WHERE
MID=@MID

DECLARE @Random int;
DECLARE @Upper int;
DECLARE @Lower int

SET @Lower = 100
SET @Upper = 150
SELECT @Random = Round(((@Upper - @Lower -1) * Rand() + @Lower), 0)

RETURN
GO

I keep getting a null value returned . Any ideas? Thanks

 

[copeZero]

forgot to mention using sql2k

thanks again

 

[SQLDenis]

well you are not returning anything are you

take a look at my last statement and compare it to yours

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[copeZero]

sorry for the wrong display i am returning

RETURN @Random

i'm actually doing this in a different procedure then the one i displayed, a more stripped down version, still no luck.

 

[AgentM]

I have a similar problem I am trying to return an integer
<CODE>
ALTER PROC [dbo].[sp_CheckIDExists]
(
@id varchar(30),
@RETURNVALUE int OUTPUT
)
AS
If (@id) Is NULL return 1

If EXISTS(SELECT ID FROM dbo.v_CI_DRIVERINFO WHERE ID= @id)
@RETURNVALUE = 0
Else
@RETURNVALUE = 1

return

</CODE>

I am getting error "Line 10
Incorrect syntax near '@RETURNVALUE'."
Any help appreciated, it's probably something silly that I am over looking.

thanks.

 

[gmmastros]

To use code blocks, use square brackets.

[ignore]

Your Code Here

[/ignore]

To fix your procedure, you need to SET the value, like this...

ALTER PROC [dbo].[sp_CheckIDExists]
(
    @id    varchar(30),
    @RETURNVALUE int OUTPUT
)
AS
If (@id) Is NULL return 1

If EXISTS(SELECT ID FROM dbo.v_CI_DRIVERINFO WHERE ID= @id)
    [!]SET[/!] @RETURNVALUE = 0
Else
    [!]SET[/!] @RETURNVALUE = 1

return

-George

"the screen with the little boxes in the window." - Moron

 

[ESquared]

See Mixed-Up Statement Types.

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.[/color]