sub-query

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Using correlated sub-queries in SQL Server

Possessing the ability to use a correlated sub-query will allow you to solve problems that other database developers cannot. Tim Chapman discusses how to use this extremely useful programming construct. A sub-query is a SQL Server statement embedded inside of another SQL Server statement. The database engine treats...

Tags: Microsoft SQL Server, Tim Chapman, Databases, server, sub-query, correlated sub-query, SQL Server Newsletter, Query, Database Engine, Execution Tree, Enterprise Software, Software, Data Management

Technical articles 2006-07-31

Additional Resources

A Study of Real-Time Query Expansion Effectiveness

This paper describes the study of an interface technique that provides a list of suggested additional query terms as a searcher types a search query, in effect offering Interactive Query Expansion IQE options while the query is formulated. Analysis of the results shows that offering IQE during query formulation leads...

Tags: Query, Study, Productivity

White papers 2006-08-06

sql query optimization

my query is taking some 2029 msec to execute and my client requirment is it must be atleast reduced to 30% , i had created the indexes on the coloumns in the where clauses, and passed parameters to the coloumns and tried but still the performance didnt improved can...

Tags: Performance management, Servers, OPEN SOURCE, neelu_munna@...

Discussion threads 2007-06-14

Creating a Query

I have created a query but when I print a report from the query, one of the field is pulling the primary key as the info instead of the name of the site, which is what I want. How do I create the query to pull the name of...

Tags: cjones@...

Discussion threads 2007-06-04

Query Maker (zip)

Microsoft .Net class library allows developers to programmatically query anything off of a Web site, converting data to name-value lists or DataTable objects. Query class can navigate multiple pages in one method call. A structured query configuration file is used to define queries, which can then be handed to the...

Tags: Query, Microsoft .Net Class Library, Data, Web Site Development, .Net, Web Technology, Application Servers, Channel Management, Middleware, Internet, Software Development, Software/Web Development, Enterprise Software, Software, Marketing

Software downloads 2005-02-09

Display two queries and include a 'Reason' column.

I'd like to combine the results of two query expressions into one query table.MsAccess I don't want to use a UNION, since I need the database to be edited from the resultant query. So far this much I have no problem doing. The problem is that I...

Tags: bjappel@...

Discussion threads 2007-11-01

Microsoft Access 2000

In a database file of 1000 names, how do I enter a check character in a field called MAILso that all records indicate YES. I know I can do it manually one record at a time, but is there a way to modify the table or create a query...

Tags: Databases, Microsoft Corp., Microsoft Access, RCBLT@...

Discussion threads 2007-04-13

how to write a search query

I am using asp.net 2 with visual web developer express and mssql express database. My question is how do i write a query i am writing query in mysql the same query how do i write microsoft sql serverselect * from emp where city like "ca*";

Tags: mssql, zubin@..., MySQL, programming, windows, SQL

Discussion threads 2006-12-04

HP Neoview Parallel Query Optimizer

The HP Neoview data warehousing platform can deliver enormous parallel power from its scaled-out grid of hundreds of commodity servers because of its industry-leading query optimizer. The Neoview Parallel Query Optimizer is unique in its ability to transform any query into a query plan that will use all of the...

Tags: Hewlett-Packard Co., Neoview Parallel Query Optimizer, Business Intelligence, Storage, Databases, Enterprise Software, Software, Data Management, Hardware

White papers 2007-01-01

4TOPS Query Tree Editor for MS Access (exe)

4TOPS Query Tree Editor is an add-in for MS Access for query development. Create queries using templates. Edit and run queries from a tree dialog. The Query Tree dialog displays the dependency tree of the selected query (Uses / Used By). The buttons on the dialogs support a natural way...

Tags: Microsoft Access, 4TOPS, Microsoft Corp., 4TOPS Query Tree Editor, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management

Software downloads 2006-10-09

Query - Last 6 months

Greetings,I need help w/ a query. Ideally I would like to pull all records from two tables for the previous 6 months. I have considered using a parameter query, but it would be better if it could be automated. Any help would be greatly appreciated.Thanks,Natalie

Tags: n.smith326@...

Discussion threads 2007-11-06

Quick Query (exe)

Quick Query is a Plug-In for Microsoft Access. It provides a context sensitive, simple way to perform SQL queries on the fly, without creating or saving a query using the standard Query Designer. You can also create queries too complex for the Query Designer. Keywords, restricted words and symbols, brackets...

Tags: Query, Quick Query, Construction, Databases, Programming Languages, Microsoft Office, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Office Suites

Software downloads 2006-10-02

How to implement Query with in a Query?

Hi every body.I have a DB in which i am implementing a Query for Search. I am ok with it. after getting this result whatever the result of the search query is I want to further put a search criteria in the searched table. but i can not do so....

Tags: Databases, khaksar_mkd@...

Discussion threads 2007-09-01

Query Optimization in Oracle Database10g Release 2

Query optimization is of great importance for the performance of a relational database, especially for the execution of complex SQL statements. This paper describes Oracle's query optimizer, a key database component that enables Oracle's customers to achieve superior performance. Oracle's query optimizer technology is unmatched in the breadth of its...

Tags: Oracle Corp., Optimization, Databases, Enterprise Software, Software, Data Management

White papers 2005-06-01

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

Exploit XML Indexes for XML Query Performance in DB2 9

DB2 9 provides pureXML storage and offers XQuery and SQL/XML as query languages. XML indexes are essential for high query performance, but their usage for query evaluation depends on how query predicates are formulated. This paper presents a set of guidelines for writing XML queries and creating XML indexes in...

Tags: XML Query, IBM DB2, XML Index, DB2 9, XML, Software/Web Development, Web Development

White papers 2006-11-02

Query-Based Distribution Groups

A query-based distribution group is a new additional type of distribution group in Exchange 2003. This new type of distribution group provides the same functionality as a standard distribution group; however, instead of specifying static user memberships, a query-based distribution group allows a person to use an LDAP query to...

Tags: Distribution Group, LDAP, Directory Services, E-mail Servers, Workforce Management, Memory, Enterprise Software, Software, Human Resources, Semiconductors, Hardware, Components

White papers 2004-07-20

SQL Inspect (zip)

SQL Inspect is a SQL editor for SQL Server, created with the aim of allowing users to quickly analyze a sub-optimal query, the tables and indexes used by that query, and record all results of rewriting the query. It offers the following features over standard SQL editor tools: Get an...

Tags: Query, SQL, Yohz Ventures Sdn Bhd, SQL Inspect, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2008-04-10

Query AD for Users with Mail Forwarder

Hello all,Please what tool would i use to query Active Directory for user with mail forwarding configured?I don't know of any tools, but you can register an event sink with a VB file to query AD for local users upon mail delivery!Google registering event sinks with AD query and you'll...

Tags: advertisement

Q&A 2006-08-07

The LINQ Project: .NET Language Integrated Query

.NET Language Integrated Query adds query capabilities to the CLR and languages that target it. The query facility builds on lambda expressions and expression trees to allow predicates, projections, and key extraction expressions to be used as opaque executable code or as transparent in-memory data suitable for downstream processing or...

Tags: Microsoft .NET, LINQ, .NET Language Integrated Query, Query Facility

White papers 2005-09-01