Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by urya

  1. urya

    Update a key column

    James, Thanks. I'll try to eliminate duplicates... I pretty much know where they are... I guess my only way is to copy the duplicate column(colB) to a new table (colB'), replace the colB with something else, and copy colB' back to colA. So to copy back ColB' to ColA, I should: UPDATE TableA...
  2. urya

    Update a key column

    When I run "update MYTABLE123 SET ColumnA=ColumnB" I get the following message. Msg 2627, Level 14, State 1, Server MYSERVER\MYSQL, Line 1 Violation of PRIMARY KEY constraint 'MYTABLE123'. Cannot insert duplicate key in object 'MYTABLE123'. The statement has been terminated. The constraint...
  3. urya

    String parameter into SQL command

    Hi all, I have a SQL command to setup a report in Crystal. I created parameter field called paramVendorID, which is String, and try to filter out records. I have: WHERE (dbo.test1.VENDORID >= {?paramVendorID}) This somehow doesn't work if I have a number at the first character. The command...
  4. urya

    Failed job cannot be removed

    I have ArcServe 2000 SP4 with Windows 2000 server SP3. One of the job failed but still at READY status. When I stop or delete the job it says. "Stop (Delete) failed." restarting the engines did not change the situation. What happened originally was that the tape was ejected while the...
  5. urya

    Import from PeachTree

    I have a problem importing from PeachTree 2000. For example, I exported accounting info from PeachTree as csv file and tried to import it through Import Wizard. However, I always get an error saying "No records are valid in selected files". I tried to use the PeachTree template...
See more

Part and Inventory Search

Back
Top