Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: DELETE using INNER JOIN

    SELECT * into #tempDocFragToDelete FROM

    DocumentFragmentRelationShipHistory WHERE DocumentFragmentMasterId =391

    AND DocumentFragmentVersionID=1.0

    DELETE a from DocumentFragmentRelationShipHistory a join #tempDocFragToDelete b

    on a.DocumentFragmentMasterId = b.DocumentFragmentMasterId

    where a.DocumentFragmentVersionID > b.DocumentFragmentVersionID

    This one is a real...

Viewing post 1 (of 1 total)