nested subquery

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Working with nested subqueries in SQL Server

Arthur Fuller provides an example that demonstrates the power of nested subqueries. He notes that nested subqueries can help you find the answers you need when the pieces are scattered across a number of tables. Many SQL Server programmers are confused about the use of subqueries, especially nested subqueries...

Tags: Microsoft SQL Server, Arthur Fuller, Databases, server, subquery, nested subquery, SQL Server Newsletter, TechRepublic Inc., Table, Enterprise Software, Software, Data Management

Technical articles 2007-01-29

Additional Resources

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

I need a help with sql nested sub query please.

Hi,I can create this view;CREATE VIEW view1 ASSELECT p.bedno, p.refno, p.surenameFROM patient pWHERE p.bedno = (SELECT bednoFROM bed WHERE bedstatus = 'USED');But when I "SELECT * FROM view1", I get this error message it says " ERROR at line 2: ORA-01427: single-row subquery returns more than one row".I need count...

Tags: alan.sarchnar@..., SQL

Discussion threads 2007-03-21

Trade tabs for tables in Word

Tabs are not tricky.Not sure whatever gave you the impression that "tabs are tricky" in Word tables. They're not nearly as tricky as managing nested tables, particularly when there are multiple editors of a document and/or if something goes awry with the nested tables.A. Tabs are a paragraph...

Tags: Van Swearingen, Microsoft Word

Discussion threads 2006-12-19

Using a PL/SQL Table in SQL

A friend of mine called a fewdays ago with a question. He wanted to populate a PL/SQL table and useit to compare to some other data via a NOT IN subquery. He was having aproblem getting the data into the nested table and wasn't sure how toaccess it from SQL...

Tags: PL/SQL, PL/SQL Table, SQL

Blog posts 2006-08-10

AnnoSuite (zip)

AnnoSuite is a powerful tool modifying properties and contents of AutoCAD annotations such as TEXT/MTEXT/ATTRIBUTE/ACDBTABLE. AnnoSuite can process nested attributes as well as normal annotations and modify nested annotations without exploding the parent block. Contents in AcDbTables can also be processed quickly. AnnoSuite contians two commands TCC for content and...

Tags: Annotation, AnnoSuite, Productivity

Software downloads 2006-05-02

Understand Oracle 10g's new multiset operators

Scott Stephens discusses Oracle 10g's new set of Advanced Multiset support operators for SQL Server 2003, which you can use with nested tables in an Oracle database. The Oracle 10g database release has a new set of Advanced Multiset support operators for SQL Server 2003, which ...

Tags: Oracle Corp., Oracle Application Server 10g, Scott Stephens, Databases, Application servers, Enterprise software, Num, nested table, Oracle Tips Newsletter, Value, Table, NUM_TAB_TYP, Storage, Programming Languages, Software, Data Management, Hardware, Software Development, Software/Web Development

Technical articles 2005-07-27

Explore Java's static nested classes and inner classes

Learn the basics about Java's two types of nested classes: a static nested class and an inner class. Also, get tips on how to make sense of the sometimes confusing semantics for creating instances of nested classes. Starting with JDK 1.1, Java provided the ability to create nested...

Tags: Java, David Petersheim, inner class, Java Tips Newsletter, Instance, Class, NestedClassTip, Programming Languages, Software Development, Software/Web Development

Technical articles 2005-08-12

Optimize SQL Server queries with these advanced tuning techniques

More good inputThanks again Tim. I've been following this line of posts because the topic has been speed. Thanks for pointing out the STATISTICS IO option. This is one of those "nuggets" that I always look forward to discovering and now that I know about it, I...

Tags: thisisfutile, technique, advanced tuning technique, Optimize SQL Server, subquery, server

Discussion threads 2007-09-18

Nested Select statements

Has anyone ever used a statement like this:Select column1, column 2, (select columnA from table2) from table1 where....?This is contrary to anything I have ever seen in SQL (especially ANSI/ISO SQL), and I would appreciate your comments. ThanksSKNo I haven't, not once in in 17 yearsmore to the point...

Tags: Databases, shelley.kuebler@...

Discussion threads 2007-11-19

Ant 1.6 for Task Writers

Starting with version 1.6, Ant supports a new way to specify nested elements in tasks. Much like the older TaskContainer interface that told Ant the task would support any Ant task as nested element one can now make the task support arbitrary subclasses of a common base class or implementations...

Tags: Task, Ant

White papers

I wish language developers would agree on the equals syntax

You forgot...... languages that have both single and double quote quoting mechanisms, too. In the languages that do, single quotes tend to be a pure literal (like take 'n' to mean "n") and double quotes get some interpretation done on them (such as "n" means "newline"). But at the end...

Tags: Justin James

Discussion threads 2007-05-17

10+ tips for working efficiently in Access? Query Design window

This article is also available as a PDF download.To create an Access query, you use the Query Design window. Youspecify a few data sources and fields, add a criteria expression or two,and perhaps specify a sort order. What you might not realize is that there'smore to working in this window...

Tags: Databases, Susan Harkins, QBE, QBE grid, Query Design window, Query Design, grid, window, Microsoft Access

Technical articles 2007-04-03

PolyGo (zip)

PolyGo is a program that creates geometrical patterns consisting of nested polygons. The principle is simple: A polygon, the base polygon of the pattern, is drawn, followed by another, similar polygon, which is reduced in size and rotated relative to the first one, so that all vertices of the smaller...

Tags: Polygon, PolyGo, Productivity, Web Site Development, Web Technology, Internet

Software downloads 2005-11-23

Mapping drive letters to local folders in Windows XP

If you could map a drive letter to a nested folder on your hard disk, then you could access nested subfolders in Windows XP just as easily as you can access shared folders on the network. Learn how to accomplish this task using the Subst command. If you regularly...

Tags: Microsoft Windows, Microsoft Windows XP, Greg Shultz, Operating systems, Windows XP Tips Newsletter, Folder, Software

Technical articles 2005-11-29

Nested folder access via UNC does not work

Hi, after about an hour of searching these forums I haven't found much so I'm hoping someone can help. Sorry for the long post.The Envrionment:There is a user called "UserA" in a child domain called "DomainA". I've got a Windows 2003 server called "Server1" sharing a folder shared as "share1"....

Tags: wildkats@..., UserA, folderA

Discussion threads 2007-09-04

Find sequence runs using Oracle's analytic functions

Bob Watkins responds to TechRepublic member Sachin Jayashekhar's question about detecting sequence runs within a group of rows, and provides a sample script that selects the first and last value in each run. In a previous tip, I described how to find gaps in sequences using Oracle's powerful...

Tags: Oracle Corp., Bob Watkins, analytic function, Sachin Jayashekhar, Oracle Tips Newsletter, Row, Sequence, Corporate Communications, Storage, Databases, Marketing, Hardware, Enterprise Software, Software, Data Management

Technical articles 2006-11-20

GLMM_SIM: A SAS Macro for Evaluating the Statistical Integrity of General Linear Mixed Models

Accommodating hierarchical or nested data has historically been problematic for researchers. General linear mixed models have the ability to account for nested data overcoming some of the limitations of the more traditional models. These advantages have made mixed modeling an increasingly popular statistical method, but questions still remain regarding the...

Tags: SAS Institute

White papers 2007-05-14

Utility-Driven Workload Management Using Nested Control Design

The emerging interests within the IT industry on utility computing and virtualization technologies have created a need for more effective workload management tools, one that dynamically controls resource allocation to a hosted application to achieve Quality of Service QoS goals. These goals can in turn be driven by the utility...

Tags: Application, QoS, Allocation, Virtualization, Utility Computing, Storage Management, Hardware, Storage

White papers 2006-03-29

Auto Debug for Windows (zip)

A Good Auto Tracing tool, Auto monitor all API and COM Interface. Supporting debug and release, not need source code. Supporting tracing COM Interface. Tracing Release version with mapfile . Supporting multithread. Supporting spying the parameters of function before and after the function is called. Supporting nested function call. Displaying...

Tags: Function, Microsoft Visual Studio, Source Code, API, Microsoft Windows, COM, Microsoft Development Tools, ActiveX/COM/COM+/DCOM, Middleware, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software

Software downloads 2006-09-15