Click here to Skip to main content
15,867,704 members
Home / Discussions / Database
   

Database

 
QuestionConnect to Oracle database from Log4net.config file Pin
forum.forum26-Apr-12 0:26
forum.forum26-Apr-12 0:26 
AnswerRe: Connect to Oracle database from Log4net.config file Pin
Eddy Vluggen27-Apr-12 8:08
professionalEddy Vluggen27-Apr-12 8:08 
QuestionYour thoughts on Database Model - KPI System Pin
DaveAuld25-Apr-12 5:50
professionalDaveAuld25-Apr-12 5:50 
AnswerRe: Your thoughts on Database Model - KPI System Pin
Eddy Vluggen25-Apr-12 7:09
professionalEddy Vluggen25-Apr-12 7:09 
GeneralRe: Your thoughts on Database Model - KPI System Pin
DaveAuld6-May-12 1:38
professionalDaveAuld6-May-12 1:38 
AnswerRe: Your thoughts on Database Model - KPI System Pin
jschell25-Apr-12 8:16
jschell25-Apr-12 8:16 
GeneralRe: Your thoughts on Database Model - KPI System Pin
Jörgen Andersson26-Apr-12 1:38
professionalJörgen Andersson26-Apr-12 1:38 
GeneralRe: Your thoughts on Database Model - KPI System Pin
DaveAuld6-May-12 1:46
professionalDaveAuld6-May-12 1:46 
Thanks for your valued input. Further to the comments made to Eddy above;

What you have shared is probably what approach I would use for data collection repository, when any given point could be recorded at any given time.

All points I am recording will be manually entered at the same time, all with the same 'end of period' timestamp.

I am using some validation logic on the post back to check which site the data is being recorded for and set any 'unused' point to zero or empty string (depending on the datatype)

Also, the views are tailored to only display the relevant collection points to the user based on site.

You have given me some more food for thought.........thanks.
Dave
Find Me On: Web|Facebook|Twitter|LinkedIn

Folding Stats: Team CodeProject


QuestionHow to create SQL Backup and Restore Server-based (.mdf) Database built in Visual Studio 2010? Pin
carm_ella24-Apr-12 0:20
carm_ella24-Apr-12 0:20 
AnswerRe: How to create SQL Backup and Restore Server-based (.mdf) Database built in Visual Studio 2010? Pin
kalaisw24-Apr-12 2:58
kalaisw24-Apr-12 2:58 
JokeRe: How to create SQL Backup and Restore Server-based (.mdf) Database built in Visual Studio 2010? Pin
Eddy Vluggen24-Apr-12 5:03
professionalEddy Vluggen24-Apr-12 5:03 
GeneralRe: How to create SQL Backup and Restore Server-based (.mdf) Database built in Visual Studio 2010? Pin
carm_ella12-May-12 23:39
carm_ella12-May-12 23:39 
AnswerRe: How to create SQL Backup and Restore Server-based (.mdf) Database built in Visual Studio 2010? Pin
Eddy Vluggen13-May-12 4:20
professionalEddy Vluggen13-May-12 4:20 
QuestionI can not drop table after upgrading to sql 2008 r2 from sql 2005 Pin
yousefshokati22-Apr-12 21:31
yousefshokati22-Apr-12 21:31 
AnswerRe: I can not drop table after upgrading to sql 2008 r2 from sql 2005 Pin
Pete O'Hanlon23-Apr-12 0:54
subeditorPete O'Hanlon23-Apr-12 0:54 
GeneralRe: I can not drop table after upgrading to sql 2008 r2 from sql 2005 Pin
yousefshokati23-Apr-12 1:02
yousefshokati23-Apr-12 1:02 
GeneralRe: I can not drop table after upgrading to sql 2008 r2 from sql 2005 Pin
Pete O'Hanlon23-Apr-12 1:13
subeditorPete O'Hanlon23-Apr-12 1:13 
QuestionSQL 2008 to SQL2005 Pin
jojoba201122-Apr-12 21:25
jojoba201122-Apr-12 21:25 
AnswerRe: SQL 2008 to SQL2005 Pin
Blue_Boy22-Apr-12 21:43
Blue_Boy22-Apr-12 21:43 
QuestionRe: SQL 2008 to SQL2005 Pin
jojoba201122-Apr-12 22:02
jojoba201122-Apr-12 22:02 
AnswerRe: SQL 2008 to SQL2005 Pin
Mycroft Holmes22-Apr-12 22:46
professionalMycroft Holmes22-Apr-12 22:46 
AnswerRe: SQL 2008 to SQL2005 Pin
Eddy Vluggen23-Apr-12 0:20
professionalEddy Vluggen23-Apr-12 0:20 
QuestionRe: SQL 2008 to SQL2005 Pin
jojoba201122-Apr-12 23:10
jojoba201122-Apr-12 23:10 
QuestionSQL Get Max for each group Pin
Richard.Berry10020-Apr-12 11:52
Richard.Berry10020-Apr-12 11:52 
AnswerRe: SQL Get Max for each group Pin
Mycroft Holmes20-Apr-12 13:40
professionalMycroft Holmes20-Apr-12 13:40 

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.