I've used Excel PivotTable to analyze data from my database because it allows me to "slice and dice" very quickly. As we know what is in our database tables, we all can write SQL queries that do what PivotTable does. But I am wondering why PivotTable can construct the queries so fast while it knows nothing about the data and the meanin...
Hi, I am looking for an Open Source & Free Browser based Adhoc / End User Reporting Tool preferably based on Java (any other technologies are also welcome). I have researched on JasperServer Pro, BIRT & Pentaho. Even though these are open source & free, the end user/adhoc reporting components needs to be paid annual license fees which...
Recently, I'm reading a book about SQL. In that book, I can't understand this term - Ad Hoc Query. I want to know what is exactly means "Ad Hoc Query" Help me, please. Thanks in advance. ...
How would I execute a query equivalent to "select top 10" in couch db? For example I have a "schema" like so: title body modified and I want to select the last 10 modified documents. As an added bonus if anyone can come up with a way to do the same only per category. So for: title category body modified return a list of...
Hello, I have a task to build asp.net C# web form to allow end user to generate sql queries. Very similar to this one: EasyQuery.NET WebForms However I'm not allowed to use any 3rd party DLL's or spend big $ on full source versions. My boss would rather force me to work overtime and re-invent the wheel. Any tips on this? Thanks! ...
Hello, My site is using Subsonic 2.2 on my site. I have 1 weird situation where I need to run some ad-hoc SQL statements. public IList<string> GetDistincList(string TableName, string FieldName) { string sqlToRun = string.Format("SELECT DISTINCT {0} FROM {1} ORDER BY {0}", FieldName, TableName); Query query = new Query(TableNam...
signer is not valid.. i noticed while i am setting up settings for build i didnt see release option in my project info->configaurations, we have to duplicate releases option and place distribution here can any one send me solution for this... ...
Hi, I have to convert a lot of legacy SQL queries to stored procs (rewriting and tidying) and I'm looking for an efficient way to compare the results one by one to ensure I haven't modified the behaviour. I currently use SQLDelta but it requires me to pipe the results of each query into tables and transfer one to a separate server usin...