test assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest...

test assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignmenttest assignment


SELECT ROW_NUMBER() OVER ( ORDER BY UM.CreateDate DESC ) AS RowNumber , UM.UserID , UM.UserName , UM.CreateDate , CAST('1/1/1900' AS DATETIME) AS RequestTime , LTRIM(RTRIM(UD.FirstName)) + ' ' + LTRIM(RTRIM(UD.LastName)) AS TutorName , UD.Country , UD.Phone , UD.CountryCode , UD.Resume , CASE WHEN UM.ActiveStatus = 1 AND UF.TutorProfileStep = 6 THEN 1 ELSE 0 END AS ActiveStatus , ( CASE WHEN UM.IsSA = 0 AND UM.IsExpertValidForAutoFlow = 1 THEN 0 WHEN UM.IsSA = 1 AND UM.IsExpertValidForAutoFlow = 0 THEN 1 WHEN UM.IsSA = 0 AND UM.IsExpertValidForAutoFlow = 0 THEN 2 WHEN UM.IsSA = 1 AND UM.IsExpertValidForAutoFlow = 1 THEN 2 END ) AS CapsuleStatus , UM.IsExpertValidForAutoFlow , ( CASE WHEN UM.IsExpertValidForAutoFlow = 1 THEN 0 WHEN TI.SourceType = 1 AND UM.IsExpertValidForAutoFlow = 0 THEN 1 ELSE 2 END ) AS CampaignTutorValidForAh , TBD.PANCardNumber FROM UserMaster (NOLOCK) UM INNER JOIN UserDetails (NOLOCK) UD ON UM.UserID = UD.UserID INNER JOIN dbo.UserFlag (NOLOCK) UF ON UD.UserID = UF.UserId INNER JOIN dbo.TutorInfo TI ON TI.TutorId = UM.UserID LEFT JOIN TutorBankDetails (NOLOCK) AS TBD ON UM.UserID = TBD.TeacherID WHERE UM.UserTypeID = 2 AND UM.UserID = COALESCE(@TutorId,UM.UserID)