Prev: Create text file
Next: Question about index usage in a query
From: Cobra on 3 Dec 2009 10:23
Hi I have a Invoice table

Record 1
Fred 10.00
Jack 25.50
Jill 67.00
Discount 10.00

Record 2
Jill 15.75
Fred 12.74
discount 12.99

etc

Is it possible to apply the discount asscoiated with record and then sum all records?


I hope I have expllained it well.

Appreciated any help

Thank You.


From: Michael Coles on 3 Dec 2009 11:13
Based on your description this looks like a denormalized table, like this:

Table1
---------
Name1 Amount Name2 Amount Name3 Amount Discount
----------------------------------------------------------------------
Fred 10.00 Jack 25.50 Jill 67.00 10.00
Jill 15.75 Fred 12.74
12.99

Is this accurate? If so, this is a very poor design.

<Cobra(a)nospamal.com> wrote in message
news:v5mdnZe3JJVISorWnZ2dnUVZ8lydnZ2d(a)giganews.com...
> Hi I have a Invoice table
>
> Record 1
> Fred 10.00
> Jack 25.50
> Jill 67.00
> Discount 10.00
>
> Record 2
> Jill 15.75
> Fred 12.74
> discount 12.99
>
> etc
>
> Is it possible to apply the discount asscoiated with record and then sum
> all records?
>
>
> I hope I have expllained it well.
>
> Appreciated any help
>
> Thank You.
>
>


 | 
Pages: 1
Prev: Create text file
Next: Question about index usage in a query