Database

Minoo S wrote:

There is more complexity to the case as there could be a row in Phone log that does not exist in Survey log and vice versa.

Minoo S wrote:

may be I should work with some scripting langauge and write a prg to match.

Minoo S wrote:

Can you think of any prg lang I could do this real quick ??

Minoo S wrote:

Any clue from this point ??

Previously Minoo S wrote:

Primary Key : I will have to put ID to make the rows unique,I think that might join the rows mentioned in original examples correctly, if I index by unique rows ??

select groupid
      ,staff1.name created
      ,staff2.name modified 
  from groups
      ,staff staff1
      ,staff staff2
 where groups.created = staff1.staffid
   and groups.modified = staff2.staffid
 order by groupid;

Chris Meech wrote:

select groupid ,staff1.name created ,staff2.name modified from groups ,staff staff1 ,staff staff2 where groups.created = staff1.staffid and groups.modified = staff2.staffid order by groupid;

INSERT INTO [table]
SELECT [col1], [col2], [col3], ...
FROM ...

crazysanker wrote:

WHERE convert(smalldatetime,dtlastdate)>= getdate()