Try this it will work
CREATE PROC [dbo].[BINDUSERS]
AS
BEGIN
SET NOCOUNT ON
Select * from (
SELECT Uid,UserName FROM UserDetails WHERE RoleId=2
UNION
SELECT 0,'All') alluser order by UserName
END
[Edit]
you can use this
CREATE PROC [dbo].[BINDUSERS]
AS
BEGIN
SET NOCOUNT ON
Select * from (
SELECT Uid,UserName, UserName as ForOrdering FROM UserDetails WHERE RoleId=2
UNION
SELECT 0,'All','~') alluser order by ForOrdering
END
[/Edit]
--Pankaj