Home Forums SQL Server 2014 Development - SQL Server 2014 Delete Row from one table if other table with multiple rows meet the condition RE: Delete Row from one table if other table with multiple rows meet the condition

  • October 9, 2013 at 9:50 am

    #1657216

    RamSteve (10/9/2013)

    here applying condition 99 is not needed as i need to delete all the rows in TableA with the same condition WHERE deleteflag is 1 for all the products

    Well so far you have seen several possibilities posted. We don't know if any of these worked for you. If they didn't we have no way of testing because still haven't seen table structures with some sample data. We are all shooting in the dark here.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/