Re: More help with query
From: Newbie (noidea_at_nospam.com)
Date: 03/11/04
- Next message: Nuno Silva: "Re: SQL Server with ASP for navision"
- Previous message: Newbie: "Re: Help with query"
- In reply to: Vishal Parkar: "Re: More help with query"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Mar 2004 08:00:08 -0000
thanks
"Vishal Parkar" <REMOVE_THIS_vgparkar@yahoo.co.in> wrote in message
news:%239gwLDyBEHA.2796@TK2MSFTNGP09.phx.gbl...
> Try:
>
> begin transaction
> UPDATE SOQuot
> SET TotalQty = (Select sum(OrderQty) FROM SODet
> where SOQuot.SalesOrder = SODet.SalesOrder
> and SODet.Line = '1')
>
> --check the data and commit/rollback accordingly.
>
> --
> Vishal Parkar
> vgparkar@yahoo.co.in
>
>
- Next message: Nuno Silva: "Re: SQL Server with ASP for navision"
- Previous message: Newbie: "Re: Help with query"
- In reply to: Vishal Parkar: "Re: More help with query"
- Messages sorted by: [ date ] [ thread ]
