function question

[brad12345]

how do i create it so the random new UmpireID is different from the @UmpireID

 

create function dbo.getSecondUmpire 
(@UmpireID int
)
returns int
as
begin
return (select TOP 1 UmpireID FROM Umpire
	order by NEWID()
	having != @UmpireID
)
end

[brad12345]

error im getting

Incorrect syntax near the keyword 'having'.

[fenway]

This is a continuation of this double-post.

 

What NEWID()?

 

TOP 1 is MS-SQL, not MySQL.