Click here to Skip to main content
11,434,695 members (46,611 online)
   

Database

 
AnswerRe: Relation multiple table using in C# Pin
Phanindra26114-Nov-12 9:23
memberPhanindra26114-Nov-12 9:23 
QuestionTrying to get a MySQL subquery to return multiple records Pin
SQL Ed12-Nov-12 9:19
memberSQL Ed12-Nov-12 9:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records Pin
Eddy Vluggen12-Nov-12 12:33
memberEddy Vluggen12-Nov-12 12:33 
QuestionSending data to database Pin
Phanindra26111-Nov-12 20:03
memberPhanindra26111-Nov-12 20:03 
AnswerRe: Sending data to database Pin
jschell12-Nov-12 11:08
memberjschell12-Nov-12 11:08 
AnswerRe: Sending data to database Pin
Mycroft Holmes12-Nov-12 13:51
memberMycroft Holmes12-Nov-12 13:51 
GeneralRe: Sending data to database Pin
Phanindra26113-Nov-12 19:40
memberPhanindra26113-Nov-12 19:40 
QuestionHow to create reports effectively [modified] Pin
Frygreen9-Nov-12 1:52
memberFrygreen9-Nov-12 1:52 
First, I am an absolute "database-beginner" Smile | :)

Here is my szenario in my daily business-live:


I have a lot (~30) different datatables which I combine to produce usefull-information.

The main topics are:
a)
My datatables are stored in xml-files. The xml-files are actually generated by reading out information from other tools in my business

b)
For the "production of usefull information" (this is reporting) I use my own proprietary C#-Programs, where I perform "the logic". Means: Filtering, Joining, Combining,.....

c)
The final result is written into Excel-Sheets. The end-users use these excel-files for their needs

Here is my question:

Especially, step b, with my proprietary C#-Programs needs a lot of time for maintenance/updates/.... due to heavily changing environment. It is time-consuming to maintain it.

How do "professional database-engineers" handle such a task?. What is their approach? Which tools are they using?

modified 9-Nov-12 7:14am.

AnswerRe: How to create reports effectively Pin
David Mujica9-Nov-12 3:32
memberDavid Mujica9-Nov-12 3:32 
AnswerRe: How to create reports effectively Pin
Mycroft Holmes9-Nov-12 5:08
memberMycroft Holmes9-Nov-12 5:08 
AnswerRe: How to create reports effectively Pin
Frygreen9-Nov-12 5:10
memberFrygreen9-Nov-12 5:10 
Suggestionsql server 2008 security Pin
Member 36227527-Nov-12 9:00
memberMember 36227527-Nov-12 9:00 
GeneralRe: sql server 2008 security Pin
Mycroft Holmes7-Nov-12 12:27
memberMycroft Holmes7-Nov-12 12:27 
GeneralRe: sql server 2008 security Pin
jschell8-Nov-12 9:56
memberjschell8-Nov-12 9:56 
QuestionHelp me my Sql expired Pin
mehdi_nassiri00986-Nov-12 11:03
membermehdi_nassiri00986-Nov-12 11:03 
AnswerRe: Help me my Sql expired Pin
Jörgen Andersson6-Nov-12 11:22
memberJörgen Andersson6-Nov-12 11:22 
AnswerRe: Help me my Sql expired Pin
Joy Sinha22-Nov-12 21:09
memberJoy Sinha22-Nov-12 21:09 
QuestionADO.NET Pin
M.T.H.Danish6-Nov-12 7:25
memberM.T.H.Danish6-Nov-12 7:25 
AnswerRe: ADO.NET Pin
Richard MacCutchan6-Nov-12 8:28
mvpRichard MacCutchan6-Nov-12 8:28 
AnswerRe: ADO.NET Pin
Eddy Vluggen6-Nov-12 10:18
memberEddy Vluggen6-Nov-12 10:18 
GeneralADO.NET Pin
M.T.H.Danish6-Nov-12 7:11
memberM.T.H.Danish6-Nov-12 7:11 
AnswerRe: ADO.NET Pin
ihoecken6-Nov-12 7:27
memberihoecken6-Nov-12 7:27 
QuestionSQL SERVER 2008 Pin
M.T.H.Danish6-Nov-12 3:49
memberM.T.H.Danish6-Nov-12 3:49 
AnswerRe: SQL SERVER 2008 Pin
David Mujica6-Nov-12 4:27
memberDavid Mujica6-Nov-12 4:27 
AnswerRe: SQL SERVER 2008 Pin
J4amieC6-Nov-12 4:31
memberJ4amieC6-Nov-12 4:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web04 | 2.8.150428.2 | Last Updated 5 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid