Select A.DocEntry As 'CallId', B.UserName As 'UserName', C.ClientName As 'ClientName', A.RpDateTime As 'ReportedDate', A.CallSubject As 'Subject', A.CallDescription As 'IssueDetails', A.Priority, A.CallType, A.[Status], DATEDIFF(Day, A.RpDateTime, GetDate()) As 'Age',D.ConsName AS 'ActionTakenBy', A.RspDateTime As 'ActionTakenat' ,A.FeedBack From BUSON_CALLLOG A Inner Join BUSON_USER B On A.UserId = B.UserId LEFT OUTER JOIN BUSON_CONSULTANT D ON A.ActBy=D.UserId Inner Join BUSON_CLIENT C On B.ClientId = C.ClientId
Select Cast(Getdate() as Date)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)