DECLARE @CrLf CHAR(2);
SET @CrLf = CHAR(13) + CHAR(10); -- CarriageReturn + LineFeed
SELECT [PROB_TYPE]
,[CONTACTNAME]
,[TECHNITION]
,[NUMBER]
--,[DESCRIPTION]
,REPLACE(REPLACE(SUBSTRING([DESCRIPTION],1,DATALENGTH([DESCRIPTION])),@CrLf,'-'), CHAR(9), '') AS [DESCRIPTION]
,[OPENED]
,[CLOSED]
,[CLOSINGREMARKS]
,[STATUS]
,[ENTERED_BY]
,[CONT_PHONE]
,[CONT_ADDRESS]
,[CONT_EMAIL]
,[TAG_NO]
,[SERIAL_NO]
,[MODEL]
,[PRIORITY]
,[SHOW]
,[CODE]
,[CLOSEID]
,[EMERGENCY_CHANGE]
,[ENTERED_ID]
,[HRS_EST]
,[HRS_ACTUAL]
FROM [problems]
where status not in ('closed')
order by prob_type
Subscribe to:
Post Comments (Atom)
Phoenix
I am resurrecting this tech blog for notes related to Azure Logic Apps with SAP.
-
While working on a project I was using a MsSQL 2012 database for my persistence layer but wanted to use a SQLITE in memory database for my u...
-
Redmine Install Process -- Download and install turnkey linux's redmine appliance http://www.turnkeylinux.org/redmine -- install up...
-
If you are a developer you probably have Visio but if you don’t https://www.draw.io/ is a great alternative and its free.
No comments:
Post a Comment