Store PRoc

Guest User

ALTER PROCEDURE [dbo].[SpGetWorkerNameList]
AS
BEGIN

SET NOCOUNT ON;
select -1 AS WorkerID, 'Select WorkName' as FirstName  
    union
Select WorkerID,FirstName From Member ORDER BY CASE WHEN WorkerID =- 0 THEN 1 ELSE 2 END ,FirstName  ; 
END

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Do it like this
ALTER PROCEDURE [dbo].[SpGetWorkerNameList]
AS
BEGIN

SET NOCOUNT ON;
DECLARE @tblWork TABLE(WorkerID INT,FirstName VARCHAR(100));
INSERT INTO @tblWork VALUES (-1,'Select WorkName');

select * from  tblWork
    union
Select WorkerID, FirstName From Member ORDER BY CASE WHEN WorkerID =0 THEN FirstName ELSE WorkId END ;
END