Guest User

Guest User

  • Tech Writer
  • 529
  • 41.9k

Store PRoc

Jun 24 2022 6:39 PM
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)