Good Morning all,
This should be easy... Just running into issues.
CR 10, SQL Server 2003
In our work order system, update records constantly. We have the standard WORK ORDER table related to the COMMENTS field by a left outer join.
I am trying to return only the latest records out of the comments field.
EX:
WORK ORDER ID - 105205
Comment 1 - 5/5/05
Comment 2 - 5/6/05
Comment 3 - 5/7/05
Let me know if you need any more information.
Thanks for your help!!!
This should be easy... Just running into issues.
CR 10, SQL Server 2003
In our work order system, update records constantly. We have the standard WORK ORDER table related to the COMMENTS field by a left outer join.
I am trying to return only the latest records out of the comments field.
EX:
WORK ORDER ID - 105205
Comment 1 - 5/5/05
Comment 2 - 5/6/05
Comment 3 - 5/7/05
Let me know if you need any more information.
Thanks for your help!!!