Let us know how that works out for you.
not sure would be appropriate to ask a different question but I'm asking anyway...
I have a table that was made using a stored procedure (make-table query). Data from this table was pulled from mutiple queries. Now, I need to update cases (or subjects) in this table (tblfuzhongtemp) from the original source query (QryFuzhongTemp). I tried the append query but keep getting cases doubled (see below).
INSERT INTO fuzhongl.tblfuzhongtemp
(BlockGroupNumber, BlockID, ParticipantID, ANickName, [Full Name], Sgender, Sdob, BAddress, BCity, BZip, [Home Phone], Aphoneo2, E_Mail,
RecruiterName, Incentive, Transportation, MNote, CheckNum, Rrecruitdate, Rassdate, Scomment, Rassplace, SAssessment, PDateScheduled, Place,
PDateAssessed, PAssessor, PNote, SAppend)
SELECT BlockGroupNumber, BlockID, ParticipantID, ANickName, [Full Name], Sgender, Sdob, BAddress, BCity, BZip, [Home Phone], Aphoneo2, E_Mail,
RecruiterName, Incentive, Transportation, MNote, CheckNum, Rrecruitdate, Rassdate, Scomment, Rassplace, SAssessment, PDateScheduled, Place,
PDateAssessed, PAssessor, PNote, SAppend
FROM dbo.QryFuzhongTemp
Could you let me know whether I should do something else to avoid the duplicates? Would this infomraiton sufficient?
again, mank thanks.
fuzhong