Strored Procedure For Adding Play List

Hi...

Am working with asp.net with vb for a MusicProject..

In this I have playlist for particular User..ie User Selects Some Songs and clicks on AddToMyPlayList Button....

Here He can insert those songs into a new playlist or update the earlier..

the StroedProcedure is as follws:  'N' means NewPlayList  and 'E' means Existing

 ***************************************************************************************

CREATE PROCEDURE MUSIC_ADD_PLAYLIST   
(   
@PLAYLIST_NAME VARCHAR(255),   
@USER_ID VARCHAR(255), 
@ItemList NVARCHAR(4000), 
@delimiter CHAR(1), 
@FOLDERNAME VARCHAR(255) ,
@PLAYLISTTYPE CHAR(1)
)   
AS   
   
SET NOCOUNT ON 

  DECLARE @IDENT INT   
 

IF @PLAYLISTTYPE = 'N'

BEGIN
 
  INSERT INTO MUSIC_PLAYLIST   
  (   
   MUSIC_PLAYLIST_NAME,   
   MUSIC_PLAYLIST_USER   
  )   
     
  VALUES   
     
  (   
   @PLAYLIST_NAME,   
   @USER_ID   
  )   
   

  SELECT @IDENT=@@IDENTITY FROM MUSIC_PLAYLIST   
  
END
 
 IF @PLAYLISTTYPE='E'

 BEGIN

 SELECT @IDENT=MUSIC_PLAYLIST_ID FROM MUSIC_PLAYLIST WHERE MUSIC_PLAYLIST_USER=@USER_ID  AND MUSIC_PLAYLIST_NAME=@PLAYLIST_NAME

 END


  DECLARE @tempItemList NVARCHAR(4000) 
      SET @tempItemList = @ItemList 
   
      DECLARE @i INT     
      DECLARE @Item NVARCHAR(4000) 
   
      SET @tempItemList = REPLACE (@tempItemList, ' ', '') 
      SET @i = CHARINDEX(@delimiter, @tempItemList) 
   
      WHILE (LEN(@tempItemList) > 0) 
      BEGIN 
          IF @i = 0 
              SET @Item = @tempItemList 
          ELSE 
              SET @Item = LEFT(@tempItemList, @i - 1) 
         -- INSERT INTO @IDTable(Item) VALUES(@Item) 


 
   INSERT INTO MUSIC_SONGSLIST  
    (Music_PlayList_Id,Music_SongName,Music_Song_Location) 
    VALUES 
    (@IDENT,@ITEM,@FOLDERNAME+''+@ITEM) 
 
   
          IF @i = 0 
              SET @tempItemList = '' 
          ELSE 
              SET @tempItemList = RIGHT(@tempItemList, LEN(@tempItemList) - @i) 
          SET @i = CHARINDEX(@delimiter, @tempItemList) 
   
  END

GO

***************************************************************************************

Here the problem is am not getting the exact result means if i add 6 songs to a playlist it is adding only 4 songs to that particular playlist..

Please help me out

Thanks in Advance,

Madhavi