Viewing 15 posts - 52,786 through 52,800 (of 59,064 total)
Heh... "Flat file cleanup on aisle 5"!
Are you all set, Kirk? Did Mark's post do what you needed (looks like it but thougt I'd double check)?
January 19, 2008 at 8:35 pm
No, no... it won't fail if the IGNORE DUPLICATES option is turned on for the unique index. It will just give a warning that at least one duplicate was...
January 19, 2008 at 7:46 pm
You have no error detection code and no rollback code... and SET XACTABORT has not been turned on to make up for it...
... so why do you need a transaction...
January 19, 2008 at 7:40 pm
I've seen requests like this before and they always puzzle me... it would appear that the name should be the primary key in this case. Yet, you have more...
January 19, 2008 at 7:34 pm
waitfor usage can bring an entire application to a grinding halt in an instant:
Not sure what you mean... how?
January 19, 2008 at 7:29 pm
If you do it right, more than you can possibly imagine...
January 19, 2008 at 7:25 pm
The following URL has a lot of good information about Excel spreadsheets and ADODB... perhaps it'll have what you're looking for...
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
January 19, 2008 at 6:56 am
Also, not sure why you'd bother pinning it... it will certainly fit in cache.
January 18, 2008 at 7:44 pm
17GB seems a bit large even if it's a Terabyte instance... if folks are using triangular joins, cursors for large record sets, temp tables for large record sets, views of...
January 18, 2008 at 7:41 pm
remember this code was done based on BOL examples, but I don't remember the topic.
First, nice idea... hadn't thought about doing it that way. Great way to import...
January 18, 2008 at 7:07 pm
Sergiy (1/14/2008)
Using "," as delimites is an error waiting to happen.
mdjtlj, ask you supplier to build a test file containing '19" Monitor'.
Then try to process that...
January 18, 2008 at 7:05 pm
My question is: is there any way I can achieve this goal without the GROUP By phrase?
I could be wrong, but I don't think there is...
January 18, 2008 at 6:33 pm
Alter table won't support a 4 part naming convention, anyway... object functions and Alter table all support 3 part naming conventions... why not use them?
January 18, 2008 at 5:19 pm
If you have 20 columns in table A, and you try to list all 20 columns in the presence of a COUNT, then you must list all 20 columns in...
January 18, 2008 at 5:13 pm
Shoot... I hope I didn't just help someone do their homework without them trying themselves, first...
January 18, 2008 at 5:08 pm
Viewing 15 posts - 52,786 through 52,800 (of 59,064 total)