We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
DECLARE @htid INT SET @htid = 71888 DECLARE @tsid INT SET @tsid = (SELECT ID FROM dbo.TimeSheetFiles WHERE hoursTrackingID = @htid AND verified = 1) --select ;with c as ( select *, dup = ROW_NUMBER() over ( PARTITION by hoursTrackingID, timesheetID, hsid order by id ) FROM dbo.HoursTracking_DetailHours WHERE hoursTrackingID = @htid AND timeSheetID = @tsid ) DELETE from c where dup > 1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Force application to connect using sql native client for mirroring||3||20|
|Delete duplicates from SQL Server table||2||27|
|SQL CAST in a Where Statement--that deals with non-numeric entries||3||24|
|SQL Server 2012 - exec sp_change_users_login 'update_one' error - The User name '' is absent or invalid.||8||18|
Join the community of 500,000 technology professionals and ask your questions.