May 16, 2008 at 9:28 am
I'm not running a DTS package, I'm not exporting to another application, I'm just running a query against the db in QA, and I'm not messing with the ANSI settings. Current settings are checked:
Set ansi_nulls
Set ansi_null_dflt_on
Set ansi_padding
Set ansi_warnings
Set quoted_identifier
Set arithabort
Set concat_null_yields_null
datatype of the field I'm returning is text, which says it holds 2^31 characters. What I'm trying to do is parse through the text of the field to find every occurrence of a specific UserID/timestamp. Don't comment on that part, I know it's ridiculous, but I need to do it.
When I run my query, QA only shows me first ~255 characters, although I can view the complete data in the GUI, so I know it's there.:crazy:
Query:
SELECT reasonnote -- text field
FROM callreasonnote
WHERE callerid = 'QMXGR481268'
----- gives me (curly braces are mine to indicate start/finish):
{reasonnote
Status changed from INPROCESS to CLOSED.
Changed User from UserID to Jonathan Crawford.
Changed User from Priority Claims to UserID.
(1 row(s) affected)
}
--- GUI shows:
{
Status changed from INPROCESS to CLOSED.
Changed User from UserID to Jonathan Crawford.
Changed User from Priority Claims to UserID.
Changed User from Inquiry Authorization to Priority Claims.
Monitor date changed from 12/31/2078 to 05/10/2007.
Changed User from Jonathan Crawford to Inquiry Authorization.
6/11/2007 1:36:30 PM UserID
This call was sitting in 'unassigned' status because it was routed to wrong bucket. Please see your lead and reroute.
7/2/2007 6:48:23 PM CrawforJ
claim subsequently adjusted, closing call
}
Any help appreciated!
Jon
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
May 16, 2008 at 10:35 am
In QA go to Tools - Options - Results tab
Maximum charcters per column -although you can only specify up to 8192!!!
May 16, 2008 at 10:35 am
Go to Tools|Options|Results tab
and set the max characters per column value higher...
May 16, 2008 at 11:15 am
Thanks to both, 8192 should work. 😀
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply