<?xml version="1.0" encoding="utf-8"?>
<jm:jupiterML 
  xmlns:jrf="Text1" 
  xmlns:jdt="Text2" 
  xmlns:jru="Text3" 
  xmlns:jpv="Text4" 
  xmlns:jsc="Text5" 
  xmlns:jrev="Text6" 
  xmlns:jre="Text7" 
  xmlns:jrs="Text8" 
  xmlns:jm="Text9" 
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  xsi:schemaLocation="Text9 File.xsd">
  <jm:mHeader
    Date="2014-03-19T06:34:29Z">
    <jm:version>0.13</jm:version>
  </jm:mHeader>
  <jm:mBody>
    <jm:Level1>
      <jm:Level2>
        <jru:Level3 
          book="book1"
          author="author1"
          year="2014">
          <jru:Level4
            color="BLC">
          </jru:Level4>
        </jru:Level3>
      </jm:Level2>
      <jm:Level2>
        <jru:Level3
          book="book2"
          author="author2" 
          year="2013">
          <jru:Level4 
            color="GRN">
          </jru:Level4>
        </jru:Level3>
      </jm:Level2>
    </jm:Level1>
  </jm:mBody>
</jm:jupiterML>

select 
from dbo.tbl_books

select book_name
from dbo.tbl_books

declare
	@book varchar(50)

select
	@book = 'book1'

set @xml.modify('
	declare namespace jm="Text9";
	declare namespace jru="Text3";
	delete /jm:jupiterML/jm:mBody/jm:Level1/jm:Level2[jru:Level3/@book!=sql:variable("@book")]')