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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
An unusual T-SQL query
You are so right Terry, it's my Foxpro background showing. In Fox you don't have to have all the columns present to do a group by and so there is little difference between a distinct and group by (except group by is faster). Forgive me I have only been using SQL Server for 2 months. I think...- SPIKEY2
- Post #7
- Forum: Microsoft SQL Server: Programming
-
An unusual T-SQL query
Why don't you SELECT * INTO <newtable> GROUP BY <columns that are duplicates> This would yeild a table without dups. Replace the old table with the new one. If you can't replace the table and have to keep it in place try Selecting into a new table with the group by or distinct and using the key...- SPIKEY2
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Xp_sendmail, adding spaces in query output
Using SQL Server 2000 Service Pack 2 Build 2195 using xp_sendmail with code : EXEC master.dbo.xp_sendmail @recipients = 'mailbox', @query = 'SELECT creditdetails FROM ic_creditcards.dbo.uk_credits_20030213', @message = '', @subject = '', @width=100, @no_header='TRUE'...- SPIKEY2
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
