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
- Order by date
-
Difficult SQL 7 Problem
Thanks for your fast reply. The data types for the first column is varchar and the second column is smalldatetime. I'm using these because the source table is set up this way. Neither column is an identity column. I've used the count column is the select output and it always turns up as 2. I...- chrismilnenaq
- Post #4
- Forum: Microsoft SQL Server: Programming
-
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
