Fastest method for union of two selects

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Fastest method for union of two selects

Message

From

25/11/2006 10:34:19

Rajesh Halyal
Raj Software
Sangli, India

24/11/2006 11:49:57

Borislav Borissov
Microcomplex
Sofia, Bulgaria

General information

Forum:

Microsoft SQL Server

Category:

Stored procedures, Triggers, UDFs

Title:

Re: Fastest method for union of two selects

Environment versions

SQL Server:

SQL Server 2000

Miscellaneous

Thread ID:

01171624

Message ID:

01172400

Views:

That works perfect.
How do I check the time reqd to execute the query (or any other way to check the performance enhancement).

If I want to add a runbalance calculated field for the same query how do I do it ?
(sorry this should be new question)

Rajesh

Map

View

Click here to load this message in the networking platform