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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- urya
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
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...- urya
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 1 Formulas
-
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...- urya
- Thread
- Replies: 1
- Forum: Data Recovery
-
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...- urya
- Thread
- Replies: 0
- Forum: Microsoft: Dynamics GP (Great Plains)
