Groups > comp.databases.ms-sqlserver > #1697

Re: Is it good to have a price column imn OrderLine table

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Is it good to have a price column imn OrderLine table
Date	2014-02-27 11:50 +0000
Organization	Erland Sommarskog
Message-ID	<XnsA2E1828E9A2D4Yazorman@127.0.0.1> (permalink)
References	<lelpn8$8sq$1@dont-email.me> <XnsA2E15CB6F8EBAYazorman@127.0.0.1> <3b417457-3d97-4877-b69c-b5dfae9938a6@googlegroups.com>

Show all headers | View raw

 (rja.carnegie@gmail.com) writes:
> And a belated thought - well, two thoughts; one is that 
> we may be doing too much of Tony's college homework;
> another is that pricing is more important on the invoice 
> than on the order.  Or maybe that's a language issue too...

But if invoice is not produced until the order is shipped, you need to 
have the price on the order line, because if you take it from the product,
you will have a bunch of angry customers on the phone. (And a few happy
customers too. But they will be silent.)

-- 
Erland Sommarskog, SQL Server MVP, esquel@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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Is it good to have a price column imn OrderLine table "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-26 23:26 +0100
  Re: Is it good to have a price column imn OrderLine table Erland Sommarskog <esquel@sommarskog.se> - 2014-02-27 08:06 +0000
    Re: Is it good to have a price column imn OrderLine table rja.carnegie@gmail.com - 2014-02-27 03:22 -0800
      Re: Is it good to have a price column imn OrderLine table Erland Sommarskog <esquel@sommarskog.se> - 2014-02-27 11:50 +0000
  Re: Is it good to have a price column imn OrderLine table Mark D Powell <markp28665@gmail.com> - 2014-02-27 11:23 -0800

csiph-web