Example of inline as part of a select statement - what I use with a custom function to translate date:
,dbo.JCP_REMEDY_TO_LOCALTIME((SELECT T8 FROM H1911 PBMHISTORY WHERE PBMHISTORY.ENTRYID = PBM.[Sys_Problem_Investigation_ID]),-6,'Y') As Closed_Date ,(SELECT U8 FROM H1911 PBMHISTORY WHERE PBMHISTORY.ENTRYID = PBM.[Sys_Problem_Investigation_ID]) As Closed_By This is without the custom function: ,(SELECT T8 FROM H1911 PBMHISTORY WHERE PBMHISTORY.ENTRYID = PBM.[Sys_Problem_Investigation_ID]) As Closed_Date See this article regarding my custom functions: Date/time = https://communities.bmc.com/communities/docs/DOC-13904 Enumerated lookup: https://communities.bmc.com/communities/docs/DOC-13903 Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mr. Tee Sent: Wednesday, June 29, 2011 7:25 AM To: [email protected] Subject: Data for "Status History" by using Microsoft SQL Server Management Studio Hi ARS-LIST, Is it possible somehow to get data for "Status History" from Remedy SQL database by using Microsoft SQL Server Management Studio? Environment is ARS and ITSM 7.5.01 patch 001. Thanks in advance. Kind regards Mr. Tee ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
