Viewing 15 posts - 16 through 30 (of 702 total)
Without all the details, it's hard to say anything definitively, but you're on the right track asking if Office has to be on the server. The server needs the proper...
March 5, 2013 at 7:19 pm
Just guessing here, but this sounds a lot like what we found trying to select data from a Netezza data appliance (Netezza is a competitor of the better-known Teradata). ...
March 5, 2013 at 6:07 pm
archie flockhart (2/26/2013)
....."Although he came through the borough of Slough, we thought his home was in rough country near Lough Earn ..."
Enuff, already.;-)
February 28, 2013 at 12:30 pm
Jamie Longstreet-481950 (2/24/2013)
February 24, 2013 at 2:54 pm
bcsims 90437 (2/21/2013)
JAZZ Master (2/21/2013)
Daniel Bowlin (2/21/2013)
uncertaintyThin ice.
SPLASH!
hypothermia
February 21, 2013 at 6:59 pm
Steven Willis (2/3/2013)
I'll say again: this is a very simplified model. What actually needs to go...
February 18, 2013 at 5:09 pm
sestell1 (2/18/2013)
Wow, interesting... and very odd.I'd be curious to know the reason behind this restriction.
+1 I'm hoping we hear an authoritative answer to this, but would guess that...
February 18, 2013 at 4:11 pm
Revenant (2/18/2013)
Ray K (2/18/2013)
The Dixie Flatline (2/18/2013)
CC#
.NET
-Java
February 18, 2013 at 3:50 pm
raguyazhin (2/14/2013)
PATINDEX('%[^0-9]%', LHP_PARAM_RESULT_VALUE) = 0
The key, then, is the Not-to-match operator, "^". Zero returned means PATINDEX() found no characters other than digits, 0-9. Got it! Thanks for...
February 14, 2013 at 10:15 pm
Went looking on the net and found an answer right here in SSC (of course!!). If you want to test for all digits, the expression NOT LIKE '%[^0-9]%' should...
February 14, 2013 at 8:43 pm
raguyazhin (2/13/2013)
HiThanks to all, This issue rectified by using PATINDEX(%[0-9]%) in Where clause.
--Ragu Thangavel
Ragu,
I'm trying to understand how you used PATINDEX() to test strings for all digits....
February 14, 2013 at 8:23 pm
Hello, and welcome to SSC.
I'm afraid there are way too many unknowns behind your question for anyone to competently answer.
Please review the tips on how to effectively...
February 14, 2013 at 2:58 pm
JAZZ Master (2/14/2013)
bcsims 90437 (2/14/2013)
crookj (2/14/2013)
Daniel Bowlin (2/14/2013)
EL Jerry (2/14/2013)
opc.three (2/14/2013)
believeCher!
share
Segment
Cuties
Oranges
Masarap
February 14, 2013 at 2:07 pm
I don't know of a way to directly tell SSIS to skip the first five rows, but offer this possible method to load your table. I did have to...
February 14, 2013 at 2:01 pm
Toreador (2/14/2013)
john.arnott (2/13/2013)
The only assumption, and a perfectly reasonable one, is that the computers involved are set to their current local time.
The other assumption is that SQLServer is running...
February 14, 2013 at 11:24 am
Viewing 15 posts - 16 through 30 (of 702 total)