• The more urgently you need something, the more time you'll need to take writing out the sample code you'd like us to mess with. A couple of things though:

    That select * statement? It won't help us figure out what the key/keys are in Table1 to uniquely identify each delete.

    General syntax though to delete:

    DELETE t1

    FROM

    Table1 AS t1

    JOIN

    Table2 AS t2

    ON t1.id = t2.id

    WHERE

    t2.colB = @parameter


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA