1
Answer

Store PRoc

Guest User

Guest User
2y
558
1 
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

 

Answers (1)
Next Recommended Forum