March 6, 2009 at 11:33 am
I have created a short CLR that writes to a file. It has the option of specifying the delimiter to use. All is well until I use tabbed delimiter. This app is written in C# in VS2005. If I run a SQL script the delimiter works just fine. If I run from a stored procedure they do not. I will see a "t" in between the fields were the delimiter would be. Executing from SSMS, it is working properly.
Does anyone have any thoughts?
Thanks
March 6, 2009 at 11:41 am
I'd say the proc isn't holding the value of the tab correctly. I've seen that kind of thing happen. You might try replacing the input value with the ASCII value in the proc, and work from there. Will that work for you?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply