Click here to Skip to main content
       

Database

 
QuestionFault Exception in WCF Services PinmemberPhanindra26114-Nov-12 6:15 
AnswerRe: Fault Exception in WCF Services PinmemberEddy Vluggen14-Nov-12 6:36 
GeneralRe: Fault Exception in WCF Services PinmemberPhanindra26114-Nov-12 8:05 
QuestionRelation multiple table using in C# PinmemberYBG13-Nov-12 2:53 
AnswerRe: Relation multiple table using in C# PinmemberPhanindra26114-Nov-12 8:23 
QuestionTrying to get a MySQL subquery to return multiple records PinmemberSQL Ed12-Nov-12 8:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records PinmemberEddy Vluggen12-Nov-12 11:33 
QuestionSending data to database PinmemberPhanindra26111-Nov-12 19:03 
AnswerRe: Sending data to database Pinmemberjschell12-Nov-12 10:08 
AnswerRe: Sending data to database PinmemberMycroft Holmes12-Nov-12 12:51 
GeneralRe: Sending data to database PinmemberPhanindra26113-Nov-12 18:40 
QuestionHow to create reports effectively [modified] PinmemberFrygreen9-Nov-12 0:52 
AnswerRe: How to create reports effectively PinmemberDavid Mujica9-Nov-12 2:32 
AnswerRe: How to create reports effectively PinmemberMycroft 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 PinmemberFrygreen9-Nov-12 4:10 
Suggestionsql server 2008 security PinmemberMember 36227527-Nov-12 8:00 
GeneralRe: sql server 2008 security PinmemberMycroft Holmes7-Nov-12 11:27 
GeneralRe: sql server 2008 security Pinmemberjschell8-Nov-12 8:56 
QuestionHelp me my Sql expired Pinmembermehdi_nassiri00986-Nov-12 10:03 
AnswerRe: Help me my Sql expired PinmemberJörgen Andersson6-Nov-12 10:22 
AnswerRe: Help me my Sql expired PinmemberJoy Sinha22-Nov-12 20:09 
QuestionADO.NET PinmemberM.T.H.Danish6-Nov-12 6:25 
AnswerRe: ADO.NET PinmvpRichard MacCutchan6-Nov-12 7:28 
AnswerRe: ADO.NET PinmemberEddy Vluggen6-Nov-12 9:18 
GeneralADO.NET PinmemberM.T.H.Danish6-Nov-12 6:11 
AnswerRe: ADO.NET Pinmemberihoecken6-Nov-12 6:27 
QuestionSQL SERVER 2008 PinmemberM.T.H.Danish6-Nov-12 2:49 
AnswerRe: SQL SERVER 2008 PinmemberDavid Mujica6-Nov-12 3:27 
AnswerRe: SQL SERVER 2008 PinmemberJ4amieC6-Nov-12 3:31 
AnswerRe: SQL SERVER 2008 Pinmemberdjj556-Nov-12 4:43 
AnswerRe: SQL SERVER 2008 PinmemberMichael Potter6-Nov-12 4:47 
GeneralAwesome solution PinmemberDavid Mujica6-Nov-12 8:39 
GeneralRe: Awesome solution PinmemberSrini Sydney14-Nov-12 11:24 
GeneralRe: SQL SERVER 2008 PinmemberMycroft Holmes6-Nov-12 12:11 
GeneralRe: SQL SERVER 2008 PinmemberMichael Potter7-Nov-12 5:23 
SuggestionRe: SQL SERVER 2008 PinmemberEddy Vluggen7-Nov-12 5:47 
GeneralRe: SQL SERVER 2008 PinmemberMichael Potter8-Nov-12 8:54 
GeneralRe: SQL SERVER 2008 PinmemberEddy Vluggen8-Nov-12 8:57 
GeneralRe: SQL SERVER 2008 PinmemberMycroft Holmes7-Nov-12 11:25 
QuestionException in Win 7 while trying to connect the application to Access DB. Pinmemberrskuchimanchi6-Nov-12 1:52 
AnswerRe: Exception in Win 7 while trying to connect the application to Access DB. PinmemberEddy Vluggen6-Nov-12 2:11 
QuestionAnsiNulls and QuatedIdentifiers default values Pinmembereli150219795-Nov-12 21:23 
AnswerRe: AnsiNulls and QuatedIdentifiers default values [RESOLVED] Pinmembereli150219795-Nov-12 22:19 
Questionexporting Table to Excel file by TSQL Problem Pingroupmehdi.sabet4-Nov-12 20:28 
AnswerRe: exporting Table to Excel file by TSQL Problem PinmemberEddy Vluggen4-Nov-12 23:48 
GeneralRe: exporting Table to Excel file by TSQL Problem Pingroupmehdi.sabet5-Nov-12 19:39 
GeneralRe: exporting Table to Excel file by TSQL Problem PinmemberEddy Vluggen5-Nov-12 23:41 
GeneralRe: exporting Table to Excel file by TSQL Problem Pingroupmehdi.sabet6-Nov-12 2:13 
GeneralRe: exporting Table to Excel file by TSQL Problem PinmemberEddy Vluggen6-Nov-12 2:21 
QuestionCase statement in where clouse with date compare Pinmemberdigvijay dobhal31-Oct-12 23:27 

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
Web01 | 2.8.140827.1 | Last Updated 1 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid