Dineedshelp
Technical User
Hi,
Need to create a stored proc that will delete duplicate records held within a table. I can get the records out that I want to remove, but can't seem to put the right statements in the right place to delete just these rows!!! Please help!!!!
So far:
SELECT bookinguniqueid
FROM dbo.Schedule
GROUP BY bookinguniqueid
having count (bookinguniqueid) > 1
Tried exsists, in alsorts!!!
Need to create a stored proc that will delete duplicate records held within a table. I can get the records out that I want to remove, but can't seem to put the right statements in the right place to delete just these rows!!! Please help!!!!
So far:
SELECT bookinguniqueid
FROM dbo.Schedule
GROUP BY bookinguniqueid
having count (bookinguniqueid) > 1
Tried exsists, in alsorts!!!