Select CallLog.CallID, CallLog.CustID, CallLog.CallType, CallLog.CallStatus, CallLog.Priority, CallLog.ClosedDate, CallLog.RecvdDate, CallLog.CallDesc, Journal.EntryText From CallLog Inner Join Journal On CallLog.CallID = Journal.CallID where CallLog.CallStatus != 'Closed'
Truncate/Trim SQL Statement?Truncate/Trim SQL Statement?
Page 1 of 1
0 Replies - 473 Views - Last Post: 01 March 2010 - 09:36 AM
#1 Guest_Knockkneed81*
Truncate/Trim SQL Statement?
Posted 01 March 2010 - 09:36 AM
I use the following statement for a report, but the report is running into issues when tryin to export it to excel. Some of the records fields are too long for Excel's cells, so the report bombs. How can I fix this issue without deleting or modifying any data in SQL? I believe there is a way to truncate table information that is pulled from SQL, so it will open in Excel (32k). What is the correct SQL statement to use to accomplish this? Any ideas is greatly appreciated.
Page 1 of 1
|
|

New Topic/Question
Reply
MultiQuote


|