question

jonesmutua avatar image
jonesmutua asked

MS SQL SERVER 2005 deleting raws in multiple tables.

Hi every one,

am new in sql server and i have a couple of hitches here and there. I Want to delete duplicates in 12 tables linked by the questionnaire profile id but it cant work in the normal view returning an error. Which is the right window or anything for that matter to do so?

Does anyone have an idea on how to go about this so that i just replace the id no. and execute it at once?

Thanks for your response, I will really appreciate.

sql-server-2005table-variabledelete-duplicates
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Squirrel 1 avatar image
Squirrel 1 answered

you have to show us how your table looks like. Post some sample data and also the required end result

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.