Viewing 15 posts - 16 through 30 (of 31 total)
Worked perfectly. I knew it was simple, just was out of my grasp for the time being. Thanks GREATLY Remi!
April 12, 2005 at 10:13 am
It's not required to be in real time, but then this would bring me to another question of how would I send out multiple phone numbers to have them compared?
Currently...
March 21, 2005 at 10:06 am
What I'm trying to do is update a field in a database to display a concatenated string to my agents for a sales type campaign that we are doing.
The information...
February 21, 2005 at 7:09 am
I ran into this type of scenario before.
Are you using the same access database (shared on a server) and being used by multiple people?
It's what I was doing and I...
February 9, 2005 at 11:05 am
I have read a few different ideas on whether to use subqueries such as what are displayed here for deleting (or updating) between two tables.
In your experiences what is normally...
November 24, 2004 at 9:09 am
They are receiving the error of basically "ODBC call failed"
And when I say refreh the links, I mean exactly that. Go into linked table manager / highlight the tables and...
November 11, 2004 at 7:26 pm
The raw table has 274 columns that I'm importing from, and all 274 columns in my database are char fields of varying lengths just so I can avoid such a...
October 29, 2004 at 9:28 am
No, they are just basic tables (no FK's,etc in them).
I had debated on trying to see if an indexed view would have halped speed things along, but am still stumped...
August 8, 2004 at 1:25 pm
Phone is the PK for both tables.
Roughly 22 Mil rows in Q22004 and ~40 Mil rows in Q12004.
The where clause was left out in the query instead of the and...
August 6, 2004 at 8:04 am
Hah, sorry for the typo's I was in a bit of a hurry.
What I get is quarterly data that we call off of. Each time I send a bunch of...
August 6, 2004 at 7:48 am
That 5 GB was free DB space, I didn't report on the log file.
But I did "find" the root of my problem I believe, and it's fairly humorous.
This SQL box...
July 22, 2004 at 3:20 pm
No indexes of any sort. No constraints,etc. Flat file import into a basic temporary holding table. All data manipulation is going to be done once the import is done.
Log file...
July 22, 2004 at 1:00 pm
Initial update time was 21 hours. On a screaming machine which is why I was under the belief that I really didn't have something right. (p4 2.8E/2 GB RAM/1 TB...
May 20, 2004 at 3:41 am
Almost no difference at all that I could see.
I'm trying to run it using the code that SQLBill has written and it doesn't seem to be exceptionally different than what...
May 19, 2004 at 12:28 pm
So my 284 column table shouldn't be so bad??
Nothing like inheriting that and then having the owner tell me how it should be able to respond to almost any query...
April 28, 2004 at 12:34 pm
Viewing 15 posts - 16 through 30 (of 31 total)