Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.
SELECT AUDIT.CurrentActor, USR.EngName, AUDIT.ReceivedDate, AUDIT.CompletedDate, AUDIT.Status FROM tbl_ServiceAudit AUDIT LEFT OUTER JOIN pr1.dbo.GetUserDetailsE USR ON USR.PERUserName = AUDIT.CurrentActor WHERE AUDIT.ReferenceNo =123291 GROUP BY AUDIT.CurrentActor, USR.EngName, AUDIT.ReceivedDate, AUDIT.CompletedDate, AUDIT.Status ORDER BY CAST(AUDIT.CompletedDate AS date) DESC
|How to add a suffix to a value in a column based on the value in another column||4||30|
|SQL works but want to get the XML node data separately||11||25|
|SQL- GROUP BY||4||21|
|Applying Roles in Common Scenarios||3||13|