• Got a Tipila, google, windows live or facebook account ?

use this to remove duplicates

update ScrOutRespondentsCompleted set Partition = -888 where Id in(
select  max(id) from ScrOutRespondentsCompleted
 where partition = 1204 
 group by RespondentId having COUNT(*) > 1
 )
 and Partition = 1204
0
votes
Hi...!!!

Tipila is a site for programmers to save interesting things found on the web, as Tips.

No more wasting time by re-googling for things you've found but forgotten.

It's totally free...
Get started now

Login to Tipila