select UPPER (issueid) as IssID,rtrim(upper(left(Description, 1)) + substring(Description ,2,len(Description ))) as Descrptn, status,priority,(select ( rtrim( upper(left(a.First_name, 1))+ substring(a.First_Name ,2,len(a.First_Name ))) +' ' + rtrim(upper(left(a.Last_Name, 1))+substring(a.Last_Name ,2,len(a.last_Name )))) from User_Details a where Emp_ID = issDtl.created_by) as Name,Created_On from Issue_Details as issDtl where project_id = 214587 and issDtl.Created_By = (select emp_id from user_details where UPPER (First_Name+' '+Last_Name ) = 'SOUVIK DUTTA')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)