Search results for query: *

Hi all: Been awhile since I posted here. I am trying to execute a simple query, however, after 4 hours it still was not complete. Is there better way to write this or it it just the nature of what i'm trying to do? Query: INSERT INTO table1(field) SELECT field FROM table2 WHERE field NOT...

Hi all: When I export my report from Access2003 to XML, then open the htm file, it opens my report just fine. Every since I upgraded to IE7 and click to open the htm file...IE7 opens...but just "spins it's wheels" and never fully opens...it's like it's stuck in a loop and my process is "pegged...

I have a text file exported from a Unisys system that I need to import into SQL Server. In several of the fields that are supposed to be numeric, the text file will actually contain a space for every value instead of a zero "0" or NULL EX: field1 numeric(5) will contain 5 spaces in the text...

Hello: I am calling a saved DTS package (com storage) and when I execute it manually or from a command prompt, it works fine. However, When I execute it from a batch file it hangs. Here's the kicker - it's intermitten. It works 20% of the time and does not work 80% of the time. I have...

I am trying to automate the recreation of the backlink thur a program (exe). I can manualy do this by opening foxpro and using the commands VALIDATE DATABASE RECOVER. however, it makes me click "OK" for every table. Is there a way to automate this process. Thanks is Advance!!! --scotta

What is the Maximum size of a Memo Field?? thanks, --scotta

hi All, I am looking for a substitute for the replace function. Here is my standard SQL: UPDATE ownertmp set parno1 = REPLACE(parcelid,'CA','00') NOTE: When I run this it tries to call a program called replace thanks --scotta

Hi All, Since I am not a programmer I am having a hard time trying to resolve this issue: SCAN IF IDFIELD = IDFIELD THEN DELETE FROM table1 WHERE year = 2002 ENDIF END SCAN Basically, I am trying to delete the old 2002 record out of my table so that only the 2003 record will show...

When I create a new database in SQLServer 2000, then view the tables thur EntMgr. I see all of the system tables. Is there an option to not view theses tables? NOTE: I know older versions of SQLServer did not show these tables. thanks in advance!! --scotta

Hi all, How does one use a VB App. to call the tables if the the tables are pointing to a different location in the dbc? Is there a way to set this location? This will need to be done on workstations that do not have FoxPro. Is this possible? thanks in advance!! --scotta

Hello all, I am Getting error when trying to import a Paradox table (*.db) The error is: "External table is not in the expected format." Yet on my other computer It imports just fine. Both computer have the exact same specs. The only difference is the Paradox drivers. The one that...

Hi all, I am trying to insert data into a table from another table Do I need to use substring w/ cursors for this? EX: table1: ------transform----------> table2: pin seqno descr pin descr 101-101 1 text 101-101 text 101-102 1 text...

Hi, Is there a way in T-SQL to compare two fields over a certain percentage? EX: SELECT [ACCOUNT NO] FROM TABLE1 WHERE VALUE1 >= %5 OF VALUE2 Weird Huh? thanks in Advance!! --scotta