T-SQL: Selecting rows to delete via joins

by 
DELETE TableA
FROM   TableA a
       INNER JOIN TableB b
               ON b.Bid = a.Bid
                  AND [my filter condition]

should work

More Related Contents:

  1. Levenshtein distance in T-SQL
  2. How to get sp_executesql result into a variable?
  3. How can I use optional parameters in a T-SQL stored procedure?
  4. Select query to remove non-numeric characters
  5. T-SQL Decimal Division Accuracy
  6. Selecting a Record With MAX Value
  7. T-SQL Pivot? Possibility of creating table columns from row values
  8. What is a “batch”, and why is GO used?
  9. TSQL divide by zero encountered despite no columns containing 0
  10. T-SQL loop over query results
  11. How to insert default values in SQL table?
  12. How to Round a Time in T-SQL
  13. How to convert a “dd/mm/yyyy” string to datetime in SQL Server?
  14. Return a value if no rows are found in Microsoft tSQL
  15. How to pivot table with T-SQL?
  16. Using Aliases in Where Clause or an Alternative Option?
  17. Extract the first word of a string in a SQL Server query
  18. Testing for inequality in T-SQL
  19. Can I use the MERGE statement in SQL Server 2005?
  20. Replace a newline in TSQL
  21. Search for one value in any column of any table inside a database
  22. Joining multiple tables returns NULL value
  23. Which join syntax is better?
  24. How to use an Alias in a Calculation for Another Field
  25. Check if a varchar is a number (T-SQL)
  26. Using a cursor with dynamic SQL in a stored procedure
  27. Truncate Datetime to Second (Remove Milliseconds) in T-SQL
  28. String.Format like functionality in T-SQL?
  29. How to parse string into date?
  30. Stored procedure hangs seemingly without explanation

Leave a Comment