How to delete multiple records from SQL Server database using a single updategram

• manibest

  Valued Member

  Points: 70

  More actions

  October 9, 2012 at 3:48 am

  #73365

  Hi there

  My database table is as below with two columns and with no primary key

  Employee (EmpNo, IsDummy)

  eg.

  1,Y

  2,Y

  3,N

  4,N

  5,Y

  My updategram is as below

  <SendRequest xmlns:updg="urn:schemas-microsoft-com:xml-updategram">

  <updg:sync>

  <before>

  <Employee IsDummy="N" />

  </before>

  </updg:sync>

  </SendRequest>

  Now I want this updategram to delete all records where IsDummy=N.

  Please find me the best way to do it as I have been trying to achieve it for long time.

  Thanks