pivot in mssql.sql

 DECLARE @UserName VARCHAR(MAX)='mata|chauhan|0|[email protected]'
 
 DECLARE @USER TABLE (ID INT IDENTITY,TITLE VARCHAR(500))     
 DECLARE @FIRSTNAME VARCHAR(500),@LASTNAME VARCHAR(500),@EMAIL VARCHAR(500),@AGENTID_REFERAL INT    
 INSERT INTO @USER SELECT * FROM DBO.SPLIT(@UserName,'|')    
 SELECT id, TITLE FROM @USER
 SELECT @FIRSTNAME = [1], @LASTNAME = [2],@AGENTID_REFERAL = [3],@EMAIL = [4]  FROM (SELECT id, TITLE FROM @USER) X PIVOT  (MAX(TITLE) FOR id IN ([1],[2],[3],[4])) Y    
 SELECT @FIRSTNAME, @LASTNAME,@AGENTID_REFERAL,@EMAIL