Viewing 15 posts - 34,201 through 34,215 (of 59,102 total)
I guess I'll have to flip them back, then. I use BCP, SQLCmd, T-SQL and my old and dearly beloved ETL friend, xp_CmdShell especially when flat files for import...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2011 at 5:14 pm
AlexSQLForums (4/22/2011)
Jeff Moden (4/22/2011)
Thanks for the response, Alex, but won't that simply disable the ability of the proxy to use xp_CmdShell at all levels?
So is this proxy user also a...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2011 at 4:53 pm
It sounds like an interview or homework question but I'll cough up what I believe are the most important...
A Table Valued Function can be used in the FROM of a...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2011 at 10:51 am
Thanks for the response, Alex, but won't that simply disable the ability of the proxy to use xp_CmdShell at all levels?
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2011 at 10:43 am
Shifting gears, if you still need help with this, let me know and I'll see what I can do over the weekend.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2011 at 9:58 am
Let's take that one step further. You can't actually have an empty string in a date, time, or datetime data type. If you try to store and empty...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 22, 2011 at 7:32 am
Considering that I missed something before, I sent the repaired code out to several folks and asked them to try to break it. As soon as I hear back...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 21, 2011 at 9:40 pm
I don't believe running totals are going to help here, folks. This isn't a flat file... it's a Hierarchy.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 21, 2011 at 5:54 pm
[font="Arial Black"] The code I had attached to this post works fine for most delimiters but has a case problem (thanks to Paul White for finding the problem) if...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 21, 2011 at 7:38 am
ChrisM@home (4/21/2011)
David Burrows (4/21/2011)
Jeff Moden (4/20/2011)
If we don't know the length, then we can force the max length for positive BIGINTs and simply remove all spaces afterwards.
Also if you append...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 21, 2011 at 7:07 am
David Burrows (4/21/2011)
ChrisM@home (4/21/2011)
Evolution in practice - don't you just love it 😀
It is darn near impossible to improve on Jeff's solutions, so must make the most of it while...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 21, 2011 at 7:04 am
David Burrows (4/21/2011)
Jeff Moden (4/20/2011)
If we don't know the length, then we can force the max length for positive BIGINTs and simply remove all spaces afterwards.
Also if you append the...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 21, 2011 at 7:01 am
sachingovind-742691 (4/18/2011)
Thanks for solutionsachin
You bet. Thank you for the feedback and, again, welcome aboard.
--Jeff Moden
Change is inevitable... Change for the better is not.
April 20, 2011 at 8:45 pm
opc.three (4/20/2011)
Many reports I have seen have been positive re: the ACE provider. Have you had a chance to try them on 64-bit?
Not yet. I hoping to do some...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 20, 2011 at 8:36 pm
Ninja's_RGR'us (4/20/2011)
Can you post the version optimized for varchar(8000) or varchar(max)?
You bet... see attached. I've included both the NVARCHAR(4000) and VARCHAR(8000) versions. The only differences are (of course)...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 20, 2011 at 7:58 pm
Viewing 15 posts - 34,201 through 34,215 (of 59,102 total)