Viewing 15 posts - 55,846 through 55,860 (of 59,078 total)
You're welcome...
Not sure what it is but being called "dear" instead of "Jeff" kinda bugs me, especially if you're a guy... must be a language barrier thing
July 11, 2007 at 7:42 am
So... post the actual name of the column that identifies individuals along with a bit of sample data for those, the actual names of the other two columns, the datatypes...
July 11, 2007 at 7:38 am
<Psssst! Bulk Insert...>
BULK INSERT dbname.dbowner.tablename
FROM '\\machinename\path\Sample.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRSTROW = 2,
ROWS_PER_BATCH = 50000
)
No need for format files or anything else...
July 11, 2007 at 7:33 am
PLEASE, don't double post...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=380596
July 11, 2007 at 7:10 am
Lookup "Expanding Hierarchies" in Books Online.
And, if you search this site for "Hierarchy", you'll also find some pretty decent procs/functions for this. If you come across any that use recurrsion,...
July 11, 2007 at 7:08 am
Heh... I think lots of folks, including me, have made that error at least once ![]()
Just a bit of an edge for performance...
July 11, 2007 at 7:02 am
You do NOT need a cursor to do this... but I need a bit more information...
July 11, 2007 at 6:58 am
Dave,
If you want to do this from an app or even TSQL itself, see the following script for how to do it... and, yes, it is a registry change...
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1854
July 11, 2007 at 6:50 am
I guess I just don't understand why you are using OpenRowSet when Bulk Insert will load the file in about two heart beats. You wanna try that, instead? Lemme know...
July 10, 2007 at 10:46 pm
Could it be that the sender of the files is sending the trigger file before the data file is received in total?
July 10, 2007 at 8:34 pm
Why wouldn't someone just use Bulk Insert on this one?
July 10, 2007 at 6:47 pm
How in the heck does RA3 equate to an RBO of 4000??? And, what is the primary key of the table? We need some more info on this one, for...
July 10, 2007 at 6:43 pm
Yes... I've changed my stance on XML, Frederick. I hate it even more simply because of it's similarity to bloat-ware... but, the folks in OPS just love what it does...
July 10, 2007 at 5:19 am
Other guesses might be that someone opened the file to see if the FTP was done or a system defrag was running.
July 10, 2007 at 4:47 am
Viewing 15 posts - 55,846 through 55,860 (of 59,078 total)