Custom Report to show changes in values on Work Order
Hi
I have been requested to add some more detail on a custom report I already have. I am creating the report in native SQL(2005). The requestor wants to be able to see what dates were changed on the ticket and by whom, ie createdtime as an example.
I can see the tables I need to use and how to join them (workorder and workorderhistory). However I am having difficulty converting the content of the prev_value column. I am trying to write a case statement so that on certain values in the wohd.columnname column I can convert the nvarchar value to a datetime that is readable ie from 1423671204377 to a recognised sql datetime. I have the code that will convert the number string but am struggling with how I convert the long number from an nvarchar.
Any help would be much appreciated.
Thanks.
Di
I have been requested to add some more detail on a custom report I already have. I am creating the report in native SQL(2005). The requestor wants to be able to see what dates were changed on the ticket and by whom, ie createdtime as an example.
I can see the tables I need to use and how to join them (workorder and workorderhistory). However I am having difficulty converting the content of the prev_value column. I am trying to write a case statement so that on certain values in the wohd.columnname column I can convert the nvarchar value to a datetime that is readable ie from 1423671204377 to a recognised sql datetime. I have the code that will convert the number string but am struggling with how I convert the long number from an nvarchar.
Any help would be much appreciated.
Thanks.
Di