test assignment test assignment test assignment test assignment

test assignment
test assignment
test assignment
test 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)