select* from

(SELECT dbo.Fatura.DtFatures, SUM(dbo.Fatura.Shuma) AS Total, SUM(dbo.Fatura.ShumaDif) AS zbritje, dbo.ForcaShitese.EmerMbiemer,

...

Thanks for the Reply. there is still a problem with displaying the Dates and doesnt total them up.

if the SAlesman have two or more invoices on the same day than...

the Table Invoice :

InvoiveId codiSM TotalInvoice TotalDiscount InvoiceDAte ClientCode

1 005 ...

If you are using the Visual Studio 2005 you can add a watch and check the Rows. On the Quick watch you can check everything that you want.

I don't know How to Thank You. That Did the Trick. Thanks a lot and I wish you a happy new Year

I actually use the mygeneration tool to create insert,update,delete, loadbyprimarykey stored procedures which works fine But I thought to give a shot to this one

any how : good work

Never mind it was some spaces that were created when I copy paste the code. I fixed and it works.

now another question when I run the stored procedure ( exec...

I try to execute the Script but I get a lot of errors

Great Article.