Try:

insert into #TempNewDok (dDocName, dID, CMSdDocName)

select D.Did

 ,D.xDocName

from DocMeta D

 join Revisions R on D.Did = R.Did

 join  CMS.dbo.DocumentHistory dh on D.xDocRevisionID = dh.did

where D.Did = (select max(D1.Did)

  from DocMeta D1

  where D1.xDocName = D.xDocName)

 and R.dReleaseDate Between...