How do I use WHILE loop in CASE statement in SQL

See more:

C#

SQL

We use CASE statement in SQL for a bool condition to get TRUE or FALSE. But in this situation I need non-bool means n'th condition and result. Actually bold part in following code. Please help. It's urgent...

What I have tried:

ALTER proc [dbo].[sp_StudentList](@CreatedBy nvarchar(max))
as

begin
declare @LikedBy nvarchar(max)=(Select LikedBy from LikeStatus)
declare @TeacherRequestID int=(Select TeacherRequestID from LikeStatus where LikedBy=@CreatedBy)

declare @UserName nvarchar(max)= @CreatedBy

DECLARE @i INT = 1
DECLARE @NumberOfRows INT = (SELECT COUNT(*) FROM TeacherRequest) 

select SP.StuThana, SP.StuDist, TR.StudentName,TR.StudentCode, TR.Class, TR.Subject, TR.StuGroup,TR.StuRelation, TR.Institute,TR.Status, TR.LikeStatus,


             CASE
		 WHEN 	
		 
		 WHILE(@i <= @NumberOfRows)
			BEGIN
				@TeacherRequestID = TR.ID THEN 'Liked' Else 'Like'		
				set @i = @i + 1       
			END	 	 

		END as LikeFlag 

from StudentsProfile SP join TeacherRequest TR on SP.CreatedBy=TR.CreatedBy


--sp_StudentList 'teacher1@gmail.com'


end