Advertisement
Dragonheart91

Untitled

Mar 10th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.35 KB | None | 0 0
  1. DELETE FROM [dbo].[BookToTaxTaxLinePosting]
  2. GO
  3.  
  4.  
  5. DELETE FROM [dbo].[BookToTaxTaxLineSource]
  6. GO
  7.  
  8. DELETE FROM [dbo].[BookToTaxAdjustmentHeader]
  9. GO
  10.  
  11. DELETE
  12. FROM [dbo].[AdjustmentContext]
  13. WHERE AdjustmentHeaderId NOT IN (SELECT Id FROM [dbo].[AdjustmentHeader] WHERE [TYPE] != 4)
  14. GO
  15.  
  16. DELETE FROM [dbo].[AdjustmentHeader]
  17. WHERE [TYPE] = 4
  18. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement