Just write two times the character you use as string delimiter if it appears in the string you want to insert.

INSERT INTO table(column1,column2) VALUES ('this is ''string'' 1','this...

Sometimes i get the same error message in Enterprise Manager when I click with the right button on a table and select "Open table --> Return all rows"...

You just need to use GROUP BY with the appropriate aggregate function(s) in the SELECT statement.

SELECT DatePart(wk, Date_field), DatePart(yyyy, Date_field), put aggregate functions here

FROM table

GROUP BY DatePart(wk, Date_field), DatePart(yyyy, Date_field)

...

You can try to set rowcount to the 'number of row to be deleted -1' like this:

set rowcount # of duplicates - 1

delete from table where key_column=key_value

set rowcount 0

(0 means...