I just need a simple store procedure which deletes a record from 2 tables. The second delete is comparing file_name field. What is the correct syntax for the second delete statement. Any help will be much appreciated. Thanks. CREATE procedure up_test_delete( @test_id int ) as delete from tests where test_id=@test_id delete from (another table) where file_name ='filename.aspx?test_id='+@test_id GO