Query

Can someone help me for a SQL query to delete all the transactions from 2
SQL table?
Here is what I want to do.
"Go thru all the transactions in both table A and B
If table A has a record, delete this record first, then delete the same
record info from B

If table A has no record reference, continue and delete the record in B"

and so on.
Thanks

MC (webmaster@ozoptics.com)  writes:
> Can someone help me for a SQL query to delete all the transactions from 2
> SQL table?
> Here is what I want to do.
> "Go thru all the transactions in both table A and B
> If table A has a record, delete this record first, then delete the same
> record info from B
>
> If table A has no record reference, continue and delete the record in B"

DELETE B
DELETE A

And most of all, don't delete row by row, delete all in one statement.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

My mistake,
Actually, I wanted to delete the records in both Table A and B, before Oct
4, 2004
MC

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
 news:Xns979040CD7705
Yazorman@127.0.0.1...
> MC (webmaster@ozoptics.com) writes: 
2 
>
> DELETE B
> DELETE A
>
> And most of all, don't delete row by row, delete all in one statement.
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx

DELETE TableA.*, TableA.DateField
FROM TableA WHERE TableA.DateField < 10/4/2004


"MC" <webmaster@ozoptics.com> wrote in message
news:OLN%23fw0TGHA.1868@TK2MSFTNGP09.phx.gbl...
> My mistake,
> Actually, I wanted to delete the records in both Table A and B, before Oct
> 4, 2004
> MC
>
> "Erland Sommarskog" <esquel@sommarskog.se> wrote in message
>  news:Xns979040CD7705
Yazorman@127.0.0.1... 
from
> 2 
same 
B" 
http://www.microsoft.com/technet/pr...oads/books.mspx 
>
>