Viewing 15 posts - 6,316 through 6,330 (of 9,725 total)
Craig Farrell (3/15/2011)
March 16, 2011 at 4:39 am
Also glad you got it working and thanks for posting the solution. That will help others with the same problems.
March 15, 2011 at 7:31 am
GSquared (3/15/2011)
Brandie Tarvin (3/11/2011)
But Parsename() only works because it's treating the IPAddress as a Server.Database.Schema.Object item (because of the...
March 15, 2011 at 7:30 am
Wow. Just finished beta-reading for Craig.
Wow.
Aren't you guys sad you can't see that article yet and jealous that I got to read it before you did! @=)
March 15, 2011 at 7:29 am
Craig Farrell (3/13/2011)
March 14, 2011 at 7:06 am
Here's a unique way of doing the special / invisible character search. Your mileage may vary:
DECLARE @y xml;
SET @y=(SELECT MyID, MyColumn
from MyTable where MyColumn=''
FOR XML RAW, ELEMENTS XSINIL);
SELECT convert(varchar(5000),@y);
EDIT: You'll...
March 14, 2011 at 6:02 am
Now that's an interesting solution I never would have thought of.
But Parsename() only works because it's treating the IPAddress as a Server.Database.Schema.Object item (because of the periods). It wouldn't...
March 11, 2011 at 12:01 pm
Ah. Stefan found the Substring version I was trying to do. I forgot about starting location in CharIndex(). No wonder I couldn't get it to work.
You're welcome, Roy. Glad we...
March 11, 2011 at 11:27 am
Here's a brute force solution:
SELECT CASE WHEN Substring(IPAddress,3,1) = '.' AND Substring(IPAddress,6,1) = '.' THEN Substring(IPAddress,1,5)
WHEN Substring(IPAddress,3,1) = '.' AND Substring(IPAddress,7,1) = '.' THEN Substring(IPAddress,1,6)
WHEN Substring(IPAddress,4,1) = '.'...
March 11, 2011 at 11:16 am
No, Lowell. Not easy at all. And it's not about price. Approvals have to go through our Corporate office. Applications are rigorously testing to make sure they are compatible with...
March 11, 2011 at 10:13 am
Much as I'd love to use one of those two options, we can't use unapproved software or components.
However, I am allowed to write up SSIS components myself... If I had...
March 11, 2011 at 9:55 am
Let me know if you need a beta-reader. Backup theory & practice is one of my favorite areas.
March 11, 2011 at 9:51 am
lijnenjoost (3/11/2011)
March 11, 2011 at 5:12 am
Viewing 15 posts - 6,316 through 6,330 (of 9,725 total)