Click here to Skip to main content
12,746,406 members (31,114 online)
   

Database

 
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 
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 
Good point. Yet shouldn't there be some sort of an adjustment record that can store that rather than leave an auditor wondering why the price was different?

Still, you need both the price history and a way to override the price (with a paper trail).
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 
AnswerRe: Subquery returns more than 1 row Pin
Eddy Vluggen24-Dec-12 2:29
memberEddy Vluggen24-Dec-12 2:29 
AnswerRe: Subquery returns more than 1 row Pin
MaulikDusara24-Dec-12 22:44
memberMaulikDusara24-Dec-12 22:44 
GeneralRe: Subquery returns more than 1 row Pin
Eddy Vluggen25-Dec-12 3:41
memberEddy Vluggen25-Dec-12 3:41 

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
Web02 | 2.8.170215.1 | Last Updated 18 Feb 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid