Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joe8079
Posting Yak Master
127 Posts |
 Posted - 2012-05-04 : 12:13:35
|
| Hi, i'm not sure which forum to put this in, but when i'm trying to display a report in report manager, i'm getting the following error: Somewhere in this table is a hexidecimal value but I cannot find it anywhere. Once I find it, i can filter this out. Does anyone know how to find this value in my table? The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.There is an error in XML document (1, 379921).'', hexadecimal value 0x18, is an invalid character. Line 1, position 379921. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-05-04 : 16:56:13
|
At position 379921 you have a character with ascii value 24 (hex 18).Edit the file and remove the offending character.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2012-05-05 : 00:08:15
|
| Thanks for the response. This column in my database has over 452,000 rows. Is there a way I can find an ASCII value of 24? I was searching on google and all the suggestions are a while loop. I'm not sure if that would be a good idea with such a large production database on that many rows. Here is the table: It has 450,000 rowsExample Below: select StreetName from house_tableStreetNameMain Street9th street |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-05-05 : 03:25:54
|
This should only take a few seconds to under a minute...SELECT * FROM dbo.House_TableWHERE StreetName LIKE '%' + CHAR(24) + '%'
N 56°04'39.26"E 12°55'05.63" |
|
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2012-05-05 : 14:33:59
|
| Thanks, I will try this on Monday. I couldn't find anything online that was helpful. So, this code will find any instance where the ascii value is 24 regardless of what position the value is in? |
|
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2012-05-07 : 11:14:54
|
| SwePeso, thank you so much!That worked. There were two records in that table out of 450,000 that had 24 as an ASCII Value. |
|
|
|
|
|
|
|
|
hexidecimal values