Nassa wrote:
> Uri dimant,
>
> Thank you so much.here is sample data.
> INSERT INTO [hesab].[dbo].[invoiceDetailTbl]
> ([GoodSysCode]
> ,[Comment]
> ,[Quantity]
> ,[Fee]
> ,[Unit]
> ,[UnitRate]
> ,[UserPrice]
> ,[SerialNo]
> ,[Size]
> ,[Color]
> ,[WareHouse]
> ,[FK_InvoiceSysCode]
> ,[DiscountPercent]
> ,[Term]
> ,[RowNo])
> VALUES
> (<GoodSysCode, int,>
> ,<Comment, nvarchar(300),>
> ,<Quantity, float,>
> ,<Fee, money,>
> ,<Unit, nvarchar(100),>
> ,<UnitRate, float,>
> ,<UserPrice, money,>
> ,<SerialNo, nvarchar(100),>
> ,<Size, int,>
> ,<Color, int,>
> ,<WareHouse, int,>
> ,<FK_InvoiceSysCode, int,>
> ,<DiscountPercent, float,>
> ,<Term, nvarchar(1000),>
> ,<RowNo, int,>)
> ------------------------------------------------------------------------------------
> INSERT INTO [hesab].[dbo].[InvoiceTbl]
> ([CustomerName]
> ,[FK_AccountSysCode]
> ,[Comment]
> ,[RecivedDate]
> ,[DelivaredDate]
> ,[PaymentDate]
> ,[InvoiceDate]
> ,[FK_DocsysCode]
> ,[ArchiveName]
> ,[UserNo]
> ,[InvoiceNo]
> ,[VisitorSyscode]
> ,[VisitorPer]
> ,[VisitorAmount]
> ,[SysDate]
> ,[Sign]
> ,[Type]
> ,[Amani])
> VALUES
> (<CustomerName, nvarchar(300),>
> ,<FK_AccountSysCode, int,>
> ,<Comment, nvarchar(300),>
> ,<RecivedDate, char(8),>
> ,<DelivaredDate, char(8),>
> ,<PaymentDate, char(8),>
> ,<InvoiceDate, char(8),>
> ,<FK_DocsysCode, int,>
> ,<ArchiveName, nvarchar(100),>
> ,<UserNo, int,>
> ,<InvoiceNo, int,>
> ,<VisitorSyscode, int,>
> ,<VisitorPer, real(24,0),>
> ,<VisitorAmount, money,>
> ,<SysDate, datetime,>
> ,<Sign, int,>
> ,<Type, int,>
> ,<Amani, bit,>)
> ------------------------------------------------------------------------------------
> INSERT INTO [hesab].[dbo].[StockTbl]
> ([Title]
> ,[Code]
> ,[BarCode]
> ,[Type]
> ,[FstUnit]
> ,[SecUnit]
> ,[UnitRate]
> ,[OrderPoint]
> ,[SalePrice1]
> ,[SalePrice2]
> ,[SalePrice3]
> ,[SalePrice4]
> ,[SalePrice5]
> ,[VisitorPer]
> ,[Comment]
> ,[DiscontPer]
> ,[UserPrice]
> ,[GroupID1]
> ,[GroupID2]
> ,[SerialNo]
> ,[Weight]
> ,[Term])
> VALUES
> (<Title, nvarchar(1000),>
> ,<Code, nvarchar(100),>
> ,<BarCode, nvarchar(100),>
> ,<Type, int,>
> ,<FstUnit, nvarchar(100),>
> ,<SecUnit, nvarchar(100),>
> ,<UnitRate, float,>
> ,<OrderPoint, real(24,0),>
> ,<SalePrice1, money,>
> ,<SalePrice2, money,>
> ,<SalePrice3, money,>
> ,<SalePrice4, money,>
> ,<SalePrice5, money,>
> ,<VisitorPer, float,>
> ,<Comment, nvarchar(300),>
> ,<DiscontPer, float,>
> ,<UserPrice, money,>
> ,<GroupID1, int,>
> ,<GroupID2, int,>
> ,<SerialNo, bit,>
> ,<Weight, real(24,0),>
> ,<Term, nvarchar(1000),>)
>
> does it help u?
> please help me,I really need it.
>
> Thanks.
> Nassa
>
> Uri Dimant wrote:
> > I'm really sorry, I have no time right now
> >
> >
> >
> > "Nassa" <nassim.czdashti@gmail.com> wrote in message
> > news:1167647822.466058.210080@42g2000cwt.googlegroups.com...
> > > Uri Dimant,
> > >
> > > sorry,can u fill it urself?
> > >
> > > Thanks,
> > > Nassa
> > >
> > >
> > > Uri Dimant wrote:
> > >> What's about posting sample data?
> > >>
> > >>
> > >>
> > >>
> > >> "Nassa" <nassim.czdashti@gmail.com> wrote in message
> > >> news:1167646933.500920.151720@n51g2000cwc.googlegroups.com...
> > >> > Uri Dimant,
> > >> >
> > >> > I send it to your e-mail.
> > >> >
> > >> > Thanks,
> > >> > Nassa
> > >> >
> > >> > Uri Dimant wrote:
> > >> >> Nassa
> > >> >>
> > >> >> Please post DDL
> > >> >>
> > >> >> CREATE TABLE blblbla (column INT......)
> > >> >> INSERT INTO blbalbla VALUES (1212121)
> > >> >> ......
> > >> >> .......
> > >> >>
> > >> >>
> > >> >>
> > >> >>
> > >> >>
> > >> >> "Nassa" <nassim.czdashti@gmail.com> wrote in message
> > >> >> news:1167642941.405036.24140@42g2000cwt.googlegroups.com...
> > >> >> > Uri Dimant,
> > >> >> >
> > >> >> > I checked that before but it gives me the wrong result.
> > >> >> > for your information:
> > >> >> > for example,if I have 4 invoices with the bellow details:
> > >> >> > In the invoice1on invoicedate 2006.8.25,goodsyscodes 1,2,3,4,5 have
> > >> >> > fees 100,100,100,100,100,respectively.
> > >> >> > In the invoice2 on invoicedate 2006.8.28,goodsyscodes 1,3,4,5 have
> > >> >> > fees 200,200,200,200,respectively.
> > >> >> > In the invoice3 on invoicedate 2006.8.30,goodsyscodes 2,4,3 have
> > >> >> > fees
> > >> >> > 300,300,300,respectively.
> > >> >> > In the invoice4 on invoicedate 2006.8.28,goodsyscodes 1 have fees
> > >> >> > 150.
> > >> >> >
> > >> >> > The results that I want:
> > >> >> >
> > >> >> > GoodSysCode LDate LFee
> > >> >> > 1 2006.8.28 200
> > >> >> > 2 2006.8.30 300
> > >> >> > 3 2006.8.30 300
> > >> >> > 4 2006.8.30 300
> > >> >> > 5 2006.8.28 200
> > >> >> >
> > >> >> >
> > >> >> > Thanks,
> > >> >> > Nassa
> > >> >> >
> > >> >> >
> > >> >> > Uri Dimant wrote:
> > >> >> >> Nassa
> > >> >> >> Try this
> > >> >> >>
> > >> >> >> The relationships bet. tables are:
> > >> >> >> dbo.InvoiceTbl LEFT OUTER JOIN
> > >> >> >> dbo.invoiceDetailTbl ON
> > >> >> >> dbo.InvoiceTbl.InvoiceSerialNo =
> > >> >> >> dbo.invoiceDetailTbl.FK_InvoiceSysCode
> > >> >> >> RIGHT OUTER JOIN
> > >> >> >> dbo.StockTbl ON
> > >> >> >> dbo.invoiceDetailTbl.GoodSysCode
> > >> >> >> = dbo.StockTbl.GoodSyscode
> > >> >> >>
> > >> >> >> WHERE invoicedate=(SELECT MAX(invoicedate) FROM invoicetbl I WHERE