Viewing 15 posts - 44,971 through 44,985 (of 59,063 total)
Cursor... my word... A very effective non-cursor solution has already been posted. Why ya gotta go swearing like that? 😉
February 23, 2009 at 4:33 pm
Hmmmm... it's starting to sound like a "connection leak", although I don't know for sure. We had that problem only once and, if memory serves correctly, we found out...
February 23, 2009 at 4:29 pm
Heh... don't feel bad... it took me half a day to figure out what I was doing wrong the first time I forgot the parenthesis.
February 23, 2009 at 12:27 pm
Heh... I'm still trying to read what may be the greatest fantasy novel of all time... every time I get close to finishing a major part of it, they rewrite...
February 23, 2009 at 11:48 am
Steve Jones - Editor (2/23/2009)
The delete is a mess....
February 23, 2009 at 11:41 am
p.s. You may have better luck if you posted this on the SSIS forum.
February 23, 2009 at 11:39 am
Yes... just sub a column name in the place of the string literal in both places.
So far as exactly how to do it in SSIS, I don't know because I...
February 23, 2009 at 11:38 am
I'd like to be able to click on a folder and select "Download" and have it create a simple file (or, 1 file each) instead of manually opening each PM,...
February 23, 2009 at 11:31 am
FULL OUTER JOIN would solve it all.
February 23, 2009 at 11:08 am
SELECT SUBSTRING('02968-01999-00013 - 9',1,CHARINDEX(' ','02968-01999-00013 - 9')-1)
February 23, 2009 at 11:05 am
I'd be happy to delete mine... right after someone tells me how to download them all. I'd like to keep the ones that still remain.
February 23, 2009 at 11:01 am
One of the few sets of "novels" I've read from start to finish is the 10 book collection for "John Carter of Mars" written by Edgar Rice Burroughs (same guy...
February 23, 2009 at 10:42 am
That would be correct... and the OPENROWSET solution I provided took that into account by using a discrete SELECT list.
February 23, 2009 at 10:37 am
Steve Jones - Editor (2/23/2009)
People can't post their own articles. They can submit them, but they're all reviewed.
And, I even phat-phingered my response... I meant to say "can't" and it...
February 23, 2009 at 10:34 am
Viewing 15 posts - 44,971 through 44,985 (of 59,063 total)