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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: chrismilnenaq
- Content: Threads
- Order by date
-
Difficult SQL 7 Problem
Hello, I'm using W2K sp2 and SQL 7 sp3. I have a table that supposedly has duplicate rows. I run this query to list the duplicate rows 'SELECT symbol, ddate FROM histdata GROUP BY symbol, ddate HAVING Count(*)>1)'. I delete the duplicate rows and run the above duplicate row statement again. And...- chrismilnenaq
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
SQL 7 Wierd table index problem
Hello, My company has been having problems with MS SQL 7. We are using W2K SP2 with SQL 7 SP3 on both machines. The problem is we dts a table to the backup server and after a few days of delete and insert statements the table becomes corrupt. We do a select into statement and try to create an...- chrismilnenaq
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
