"Erland Sommarskog" <esq***@sommarskog.se> wrote in message
news:Xns979040CD7705Yazorman@127.0.0.1...
> MC (webmas***@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, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

"MC" <webmas***@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" <esq***@sommarskog.se> wrote in message
> news:Xns979040CD7705Yazorman@127.0.0.1...
> > MC (webmas***@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, esq***@sommarskog.se
> >
> > Books Online for SQL Server 2005 at
> >

> > Books Online for SQL Server 2000 at
> > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
>