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 wOOdy-Soft 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
-
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...- urya
- Post #4
- Forum: Microsoft SQL Server: Programming
-
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)
