Help with special sort order wanted

I have the following sp:

CREATE PROCEDURE [dbo].[spUserGet]
@UserID nvarchar(50)
AS
BEGIN

SELECT UserID,
UserName
FROM vwUser
ORDER BY UserName

END

I need help with changing the sort order so that the UserName attached
to @UserID always is shown first and then the rest of the users sorted
by UserName. How can this be done?

Best regards,

S

One solutions is to use a union, like so;



CREATE PROCEDURE [dbo].[spUserGet]
@UserID nvarchar(50)
AS
BEGIN
SELECT UserID,
UserName from
(

SELECT UserID,
UserName , 0 as SortOrder
FROM vwUser
where userid = @userid

union

SELECT UserID,
UserName, 1 as SortOrder
FROM vwUser
where userid != @userid

)t
ORDER BY SortOrder, UserName
END

(untested)

Paddy