Post reply

trouble deleting from a table

  • February 23, 2007 at 6:06 am

    #123004

    I need to delete rows from a table where col1 is within a range of values and col2 of the same row is within a certain range of values. how is this possible?

  • February 23, 2007 at 6:16 am

    #691367

    DELETE FROM MyTable

    WHERE col1 BETWEEN @a AND @b-2

    AND col2 BETWEEN @C AND @d

    Read about BETWEEN in Books Online before you use this so that you understand how it deals with values that are exactly equal to the upper and lower limits.

    John

  • February 23, 2007 at 7:17 am

    #691379

    thank you very much! this done the trick!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply