Click here to Skip to main content
11,581,186 members (61,188 online)
   

Database

 
AnswerRe: Trying to get a MySQL subquery to return multiple records Pin
Eddy Vluggen12-Nov-12 11:33
memberEddy Vluggen12-Nov-12 11:33 
QuestionSending data to database Pin
Phanindra26111-Nov-12 19:03
memberPhanindra26111-Nov-12 19:03 
AnswerRe: Sending data to database Pin
jschell12-Nov-12 10:08
memberjschell12-Nov-12 10:08 
AnswerRe: Sending data to database Pin
Mycroft Holmes12-Nov-12 12:51
memberMycroft Holmes12-Nov-12 12:51 
GeneralRe: Sending data to database Pin
Phanindra26113-Nov-12 18:40
memberPhanindra26113-Nov-12 18:40 
QuestionHow to create reports effectively Pin
Frygreen9-Nov-12 0:52
memberFrygreen9-Nov-12 0:52 
AnswerRe: How to create reports effectively Pin
David Mujica9-Nov-12 2:32
memberDavid Mujica9-Nov-12 2:32 
AnswerRe: How to create reports effectively Pin
Mycroft Holmes9-Nov-12 4:08
memberMycroft Holmes9-Nov-12 4:08 
Frygreen wrote:
My datatables are stored in xml-files. The xml-files are actually generated by reading out information from other tools in my business

This is just wrong - extracting data from other tools is valid, moving them to xml files is probably the worst platform to work from.

Get hold of sql server, use Express if cost is an issue (has a size limit of 4gb). Your current xml files can be loaded into tables in a sql sever database.

I would seriously think about getting someone to normalise and organise your data for you it is a non trivial job. Although if you have already done this with xml you may be able to handle it.

Use SQL Server Reporting Services SSRS to produce your canned reports (no analysis or drill down) and look into Integration Analysis Services for data analysis beyond the static reporting requirement.

I may sound SQL Server centric b/c I am, it is by far the best tool for departmental database processing. Don't piss about with Access or Excel go straight for the professional tools.
Never underestimate the power of human stupidity
RAH

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

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.150603.1 | Last Updated 6 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid