shoaib shamsuddin

shoaib shamsuddin

  • 1.8k
  • 386
  • 11.8k

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)