change second query to below to match the resultsets

Select Distinct orderId,orderDate

From orders

Inner join orderDetails

On orders.orderId=orderDetails.orderId

Where orderDetails.unitePrice>3

In this case both will have same kind of performance;-)

You may be interested in following article

http://weblogs.sqlteam.com/mladenp/archive/2007/05/18/60210.aspx

I think both the queries will not give same results, Please check again specially for the case of (ONE -> MANY), If a single order may have multiple detail records...

totally agree with you..

SQL Server is not a correct tool for this kind of requirement, but I am suggesting him that it is possible to open a IE browser thru...

Did you tried this?

Exec xp_cmdshell '"C:\Program Files\Internet Explorer\iexplore.exe"'

Another way of doing this

CREATE TABLE Emp (Emp_id INT, Emp_name VARCHAR(50), Supervisor_id INT)

GO

Insert Emp

SELECT 1, 'A', -1 UNION

SELECT 2, 'B', 1 UNION

SELECT 3, 'C', 1 UNION

SELECT 4, 'D', 2

GO

WITH Emp_CTE...

have you heard about recursive CTE? google about it or read BOL

Check this tutorial

http://technet.microsoft.com/en-us/library/ms169673(SQL.105).aspx

try this query

SELECT A.Order_No AS 'Order_No',

'Name'= CASE WHEN A.New = 1 THEN A.Name ELSE '' END,

a.Cnt as Total_Cnt,

A.Party, A.Shipped_Cnt, 'Pnd_Cnt' = A.Cnt - A.Shipped_Cnt into #temp

FROM

(select M.Order_No,M.Name,M.Cnt,C.Party,C.Shipped_Cnt, 'New' =...

you may want to look at "SYS.PARAMETERS"

See this

DECLARE @dt DATETIME, @WeekNumber INT

SET @dt='03/01/2010'

SELECT @WeekNumber=DATEPART(wk,@DT)

SELECT @WeekNumber

Add Expressions->executable property to the variable and try executing it

Above solution is for SQL 2000 🙂

try this

create table #_TEST (

_ID int,

_VAL1 int,

_VAL2 int,

_VAL3 datetime,

_IndicatorCol bit

);

insert into #_TEST (_ID, _VAL1,...

Try this

create table #DMVRunningPerformance (

Symbol_vc varchar(25),

DayID_in int,

...