An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools. This is in contrast to any query which is predefine and performed routinely.
Questions tagged [adhoc-queries]
39 questions
0
votes
3 answers
Performance tuning of ERP System called axavia
I'm working here in a small company and one of my jobs is the administration of the ERP system 'AXAVIA' (www.axavia.com)
There are .NET Clients and a MSSQL Server 2005 Database with a size of about 10GB.
The system works on a metadata model, this…
Christoph Staudinger
- 75
- 1
- 9
0
votes
1 answer
about ADHOC build -getting error when i install it to my device
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...
Linux world
- 3,750
- 11
- 44
- 59
0
votes
1 answer
web form to generate ad-hoc sql statements
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…
aron
- 2,856
- 11
- 49
- 79
0
votes
2 answers
Ad-hoc SQL and inline function giving different results
In MS SQL Server 2012 SP1, when I execute:
SELECT rt.RoleId, ur.RoleName, app.ApplicationName
FROM [TV_ClientPortal].[dbo].[UserRoleTie] rt
JOIN [TV_ClientPortal].[dbo].[UserRoles] ur
ON rt.RoleId = ur.RoleId
…
prmph
- 7,616
- 11
- 37
- 46
0
votes
1 answer
How to load the xhtml document as a text and search the keyword in marklogic
I have loaded the XHTML files in marklogic. But need to perform the search on attributes, elements and text.
So I need to get/load the document as a text and perform the search on document.
Below is the XHTML file.
user3902356
- 25
- 8
-1
votes
1 answer
Incorrect number of query parameters in Moodle *How to get the external links from course page
My Dear
I tried to run the following ad-hoc database query in Moodle but i got it error
there any way to fix it , thanks
*My target to find all the external links (URL) from course page
SELECT
concat('
Ahmed Abdulaziz
- 39
- 6
-1
votes
1 answer
Get overlapping dates between two date ranges (in columns) - WITHOUT creating database objects
I have a tricky situation in Microsoft SQL Server 2016, in which I need to get a list of dates that an employee was in Leave of Absence (LOA) in a PayPeriod, with fixed PeriodStart and fixed PeriodEnd columns.
See the figure below (the source…
user3812887
- 439
- 12
- 33
-1
votes
2 answers
Get DISTINCT records on INNER JOIN SQL Server
I have two tables. I have query that joins the first table to second table via INNER JOIN clause. The results show that there are redundant or duplicate results. In my example below the results have 4 records. I want to distinct the SdiID and I'm…
Jobert Enamno
- 4,403
- 8
- 41
- 63
-2
votes
1 answer
How do tech companies go about building ad-hoc query functionality of NoSQL data?
I’m looking for a good architecture to be able to efficiently query data currently stored in NoSQL dbs (specifically DocumentDB).
We have a number of microservices that manage various entities (say client, product etc). Each store their data locally…
Andrei
- 1
- 1