TechRepublic Resources
- Access Query not doing what I need
- I have a database that has several tables that are all linked with a relationship on a field that contains a unique numeric ID. I need to run a query that pulls data from two of the tables and all attempts so far are not giving me the output...
- Tags: access, alcottrj@..., Microsoft Access, programming, queries, query, software, sql, Table B
- Discussion threads 2007-03-07
- Working with nested subqueries in SQL Server
- Example: Bad! Subqueries: WORSE!Firstly, the example given here is an extremely poor one because Using IN creates a temp table for every item in the IN list. If each of these subqueries only returns 10 records, this query will create 1000 temp tables. Very inefficient. SQL is not designed to...
- Tags: subquery, Jeff_D_Programmer, sql scripting, software, programming, queries, sql, sql query, query, join, Microsoft SQL Server, server
- Discussion threads 2007-01-30
- How do I... Generate a running total in an Access query?
- Have you had success using this query technique? What are some other workarounds you use on a regular basis?Do not use this techniqueon a big table, well not unless it's a convenient time for a coffee break. Beware of nulls in the data you ar
- Tags: Databases, JodyGilbert
- Discussion threads 2006-12-04
- Stupid Active Directory Question
- How the heck do I get a list of the *active* users in Active Directory? It seems like the simplest of requests, but I can not find any information about how to do it (though I did read somewhere that you *can't* do it?!). Help!define activeDo you mean...
- Tags: active directory, domain, domain controller, Menace65, queries, server, software, Value at Risk, windows
- Discussion threads 2006-10-11
- How do I... create a crosstab query in Microsoft Access?
- Have you used crosstab queries to produce specialized reports of aggregated data? What kinds of problems or shortcomings have you encountered with the technique?
- Tags: crosstab, hardware, how do i, JodyGilbert, microsoft access, Microsoft Corp., queries, tim chapman
- Discussion threads 2006-09-29
- Customize database queries using views in PostgreSQL
- Does you query satisfy?The downloadable version of this article is available here:http://techrepublic.com.com/5138-3513-6032029.htmlAre you ever really happy with the performance of your queries or are you merely content that it’s the best you can do? Is there another aspect of PostgreSQL you would like to see covered in a TechRepublic download?Caution...
- Tags: database, Mark W. Kaelin, mellonfire, performance, postgresql, programming, queries
- Discussion threads 2006-01-27
- Access query
- I currently have a linked DBF extract from my Primary system that includes 2 fields; one with the date, and another with the time. I need to be able to capture data for a 24 hour period of time beginning at 3:00am in the morning and ending at 2:59:59 in...
- Tags: access, Access Query, database, dateTime, FHP, microsoft, Microsoft Access, queries, software, sql statements
- Discussion threads 2006-01-17
- Displayging Querie results from multiple tables in a form
- I have a form I am using to Edit records from two joined table records. If it finds a match in the second table it works fine. I want to use a copy of the form to add new records to the second table. The first table has the master...
- Tags: second table
- Discussion threads 2006-01-04
- Some queries about my career
- I am a 23 year old engineer now completing more than a year in Infrastructure Support Industry.I have cleared ny CCNA and regarding my next one I am in a sort of confusion..I always wanted to learn linux right since my college days and now teh craving is even more.And...
- Tags: Linux, career
- Discussion threads 2005-12-19
- Specify data types in Access parameter queries
- What if the query is too complex for the design view ?This article is fine for those who use the query design view. But, in the world of real applicstions, some SQL queries are reported by the design view wizard as being "... too complex ... ". In such cases,...
- Tags: access, datatype, hardware, kaspencer, Microsoft Access, parameters, queries, SQL, SQL View
- Discussion threads 2005-05-25
- Occasional Access users may need a crash course in the basics
- If you're looking for a handy guide to working with Microsoft Access, check out Tech Toolshed's Access reference charts.Three of the charts target the basics of working with tables, queries, and reports.A fourth chart provides tips and shortcuts for performing various Access tasks.Microsoft Access isn't in every user's software repertoire.Those...
- Tags: Microsoft Access, database, Queries
- Technical articles 2004-11-04
Additional Resources
- Optimize SQL Server without rewriting queries
- Sluggish SQL Server database performance can be caused by many factors besides just poorly designed queries. While there is certainly a correlation between the quality of your queries and your server's performance, queries aren't always the problem when SQL Server underperforms. This article offers a variety of methods for optimizing...
- Tags: Query, Microsoft SQL Server, Server, Databases, Enterprise Software, Software, Data Management
- Download resources 2005-03-02
- DDBQ (exe)
- Dynamic DataBase Queries (DDBQ) software is an application for creating dynamic database queries in a graphical user interface, for any database. Queries may contain from simple to complex database dependent functionality, such as stored procedures, functions. Users may describe as many queries as they like, and store them for future...
- Tags: Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Software downloads 2006-10-26
- AY Spy (exe)
- Seemlessly use DNS, Whois, RWhois, SMTP, Finger, ICMP queries without knowing anything about these protocols. Automatically direct your queries using our unique database of Internet servers from more than a hundred fifty countries. Easily navigate through the queries using browser-like point-and-click interface.
- Tags: Query, E-mail, Internet, Domain Names, Networking, Online Communications
- Software downloads 2007-04-30
- Shorten development time by using parameterized queries in ADO.NET
- Parameterized queriesThe downloadable version of this article is available here:http://downloads.techrepublic.com.com/abstract.aspx?docid=239145What is your preferred method of data access? Will you give parameterized queries a try?
- Tags: Shorten, .net, application development, ado.net, zach smith, Mark W. Kaelin, programming, Microsoft ADO.NET
- Discussion threads 2006-07-12
- queries in Access 2000
- Help! I am new to Access and am wondering if it is possible to have one report access multiple queries...Thanks!Sort ofYou should make another query that combines the other queries. Then build a report from that one query.YesUse Sub-reports. Email me if you need more help at rparthas@mhcable.com. Best, RajeshA...
- Tags: melissa.donovan@..., Microsoft Access, software
- Discussion threads 2004-10-20
- Mastering XML DB queries in Oracle Database 10g Release 2
- With rapidly multiplying volumes of XML data, XML queries can no longer be carried out by building resource-hungry DOM trees in memory for functional evaluation of XML documents. Oracle has made a major breakthrough in its XML DB product to holistically process XML data with higher efficiency in both space...
- Tags: Oracle Corp., XML Query, Oracle Database, Oracle Database 10g, XML, Software/Web Development, Web Development
- White papers 2005-03-01
- Query Translation From XPath to SQL in the Presence of Recursive DTDs
- This paper studies the problem of evaluating XPATH queries over XML data that is stored in an RDBMS via schema-based shredding. The interaction between recursion in XPATH queries and recursion in DTDS makes it challenging to answer XPATH queries using RDBMS. The paper presents a new approach to translating XPATH...
- Tags: SQL, DTD, XPath, XML, Software/Web Development, Web Development
- White papers 2006-01-27
- Programming ADO to Execute SQLXML queries
- The objective of this webcast is to introduce Visual Studio developers to the basics of using ADO in Microsoft Visual Studio 6.0 and ASP applications to access SQL Server data as XML by executing SQLML queries. The listener will learn about the underlying architecture of using ADO to execute SQLXML...
- Tags: Microsoft Visual Studio, Microsoft Corp., Programming, XML, Microsoft Development Tools, Software/Web Development, Web Development, Development Tools, Software Development
- Webcasts
- SQL Server 2005
- Can someone tell me what the best tools for creating, editing, and designing queries, functions and views for SQL Server 2005? I want to create some cool complex queries.The query window, a knowledge of SQL, database design and intellect.You should also be aware that unnecessarily complex queries are not cool.
- Tags: Databases, Enterprise software, willgates@..., Microsoft SQL Server 2005, Microsoft SQL Server
- Discussion threads 2007-04-26
- << Previous
- page 1 of 1
- Next >>
