Hi,

I'm trying to delete data from two tables called [BizQuotes] and [BizQuotes_QuotedProducts].

All the quoted products are stored in the [BizQuotes_QuotedProducts] table and they are connected to the [BizQuotes] table by foreign key. I want to delete all the quotes in the [BizQuotes_QuotedProducts] table first before deleting the linked quote in the [BizQuotes table]. Here is my code in the 01.00.00 SQLDataprovider file

*************

create procedure {databaseOwner}{objectQualifier}BizQuotes_DeleteQuote

@QuoteId int

as

DELETE FROM {objectQualifier}BizQuotes CROSS JOIN {objectQualifier}BizQuotes_QuotedProducts
WHERE (BizQuotes_QuotedProducts.QuoteId = @QuoteId) AND (BizQuotes.QuoteId = @QuoteId)

this is the first time i've attempted something like this as im not quite SQL Savvy but hopefully im not too far off. What am i missing?

Thank you sebastian,

that worked a treat. So simple i should have really tried that rather than trying to be too clever