Viewing 15 posts - 6,316 through 6,330 (of 9,722 total)
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
opc.three (3/10/2011)
Curious, what is @ doing in your command line? This is what I get when I run your code:
"D:\Program Files\Winzip\wzzip.exe" -m \\MyServer\MyShare_dev\Folder1\Processed\Group\Item\Details_201103101058.zip @\\MyServer\MyShare_dev\Folder1\Processed\Group\Item\Details.lst
Just a hunch...try surrounding your file...
March 11, 2011 at 5:00 am
hor_netuk (3/11/2011)
March 11, 2011 at 4:27 am
It's the Attack of the Acronyms!
Two years ago, we implemented a new process that uses the acronym "RI". I've been working on that process ever since. I've gotten so ingrained...
March 10, 2011 at 10:15 am
Viewing 15 posts - 6,316 through 6,330 (of 9,722 total)