Click here to Skip to main content
12,751,306 members (35,161 online)
   

Database

 
QuestionRe: how to cast real data type in sql server 2005 Pin
Eddy Vluggen4-Jan-13 23:52
memberEddy Vluggen4-Jan-13 23:52 
QuestionSql server like clause Pin
rubonkumar28-Dec-12 5:44
memberrubonkumar28-Dec-12 5:44 
AnswerRe: Sql server like clause Pin
Richard MacCutchan28-Dec-12 7:05
mvpRichard MacCutchan28-Dec-12 7:05 
AnswerRe: Sql server like clause Pin
PIEBALDconsult28-Dec-12 7:38
memberPIEBALDconsult28-Dec-12 7:38 
GeneralRe: Sql server like clause Pin
Mike Meinz28-Dec-12 7:49
memberMike Meinz28-Dec-12 7:49 
GeneralRe: Sql server like clause Pin
rubonkumar28-Dec-12 20:08
memberrubonkumar28-Dec-12 20:08 
AnswerRe: Sql server like clause Pin
rajarao3044-Jan-13 1:50
memberrajarao3044-Jan-13 1:50 
QuestionDatabase design question Pin
DavidCrow27-Dec-12 16:22
memberDavidCrow27-Dec-12 16:22 
I'm not designing a purchase order system per se, but it is the closest thing to what I'm actually doing so that's why my question/concern involve it. In a "minimal" PO system, you have the following tables:

Customers
Orders
Order Details
Products

When an order is first created (e.g., #123), product descriptions and prices are pulled from the Products table. That order is marked as paid. A few months go by and some of the products in the Products table get updated with new prices. Now what happens when I look at order #123 and its details? The price of that order will no longer match the sum of its individual products. Is that common? Am I looking at this from the wrong angle?

Thanks.

- DC

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"Show me a community that obeys the Ten Commandments and I'll show you a less crowded prison system." - Anonymous


AnswerRe: Database design question Pin
PIEBALDconsult27-Dec-12 16:52
memberPIEBALDconsult27-Dec-12 16:52 
AnswerRe: Database design question Pin
jschell28-Dec-12 11:16
memberjschell28-Dec-12 11:16 
GeneralRe: Database design question Pin
PIEBALDconsult28-Dec-12 15:42
memberPIEBALDconsult28-Dec-12 15:42 
GeneralRe: Database design question Pin
jschell30-Dec-12 9:28
memberjschell30-Dec-12 9:28 
AnswerRe: Database design question Pin
Mycroft Holmes28-Dec-12 12:05
memberMycroft Holmes28-Dec-12 12:05 
QuestionImporting of Huge fixed width text file in sql server table Pin
ibrahim sharief27-Dec-12 10:24
memberibrahim sharief27-Dec-12 10:24 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
PIEBALDconsult27-Dec-12 15:08
memberPIEBALDconsult27-Dec-12 15:08 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
Deepak Kr130-Dec-12 21:29
memberDeepak Kr130-Dec-12 21:29 
AnswerRe: Importing of Huge fixed width text file in sql server table Pin
jschell31-Dec-12 10:14
memberjschell31-Dec-12 10:14 
Questionshow Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
hadeed147227-Dec-12 7:52
memberhadeed147227-Dec-12 7:52 
AnswerRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
djj5527-Dec-12 8:53
memberdjj5527-Dec-12 8:53 
GeneralRe: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Pin
hadeed147227-Dec-12 9:03
memberhadeed147227-Dec-12 9:03 
QuestionSQL BulkCopy using IDataReader - how can you cast the fields? Pin
Allan Watkins26-Dec-12 20:12
memberAllan Watkins26-Dec-12 20:12 
AnswerRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
Mycroft Holmes26-Dec-12 21:32
memberMycroft Holmes26-Dec-12 21:32 
GeneralRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
AllanW1111127-Dec-12 7:02
memberAllanW1111127-Dec-12 7:02 
AnswerRe: SQL BulkCopy using IDataReader - how can you cast the fields? Pin
PIEBALDconsult27-Dec-12 9:48
memberPIEBALDconsult27-Dec-12 9:48 
QuestionSubquery returns more than 1 row Pin
Jassim Rahma24-Dec-12 2:02
memberJassim Rahma24-Dec-12 2:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.170215.1 | Last Updated 20 Feb 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid