Search results for query: *

Hi Guys: Thanks for you answers. The query is what it is. Just trying to insert values from table1.field1 into table2.field2 where the values do not exist in table2.field2 The exact query is as follows: INSERT INTO APPEAL(APIN) SELECT RPIN FROM RMAST WHERE RPIN NOT IN(SELECT APIN FROM APPEAL)...

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...

Hi Mike, I am using Ver.6. Version 7 has the abilty to by-pass the "OK" menus when trying to re-create the backlink from a program(exe)? Thanks, --scotta

Thanks for the Commands Ramani, However, when I build the executable and run it, it gives me the error message of: "Command is only allowed in interactive mode" Here are my commands: SET CONFIRM OFF SET SAFETY OFF OPEN DATABASE test01 VALIDATE DATABASE RECOVER EXIT Thanks for your...

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

Thanks for the response, however in our VB apps. we do not use OLEDB but ODBC. Any suggestions? thanks rgbean --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...

Appreciate you all help The Function was created successfully, however the insert statement gives me this Error: "'swamp' is not a recognized function name." I looked in the sp_help and i can see it but it just does not want to reconize it. Any ideas? thanks, --scotta

Thanks for the input, however, when I try and run your function create script (mofified of course)I get an "Incorrect syntax near the keyword 'declare'." error I am running SQLServer2000 w/SP3. thanks for all your help!! --scotta

This move is a one time insert so that our software can read the database properly thanks, --scotta

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