I actually liked this question. Not only was it a reminder to test things that BOL is ambiguous or unclear about, but it was a prompt to me to...

I think you're out of luck trying to INSERT to multiple tables. Even if it were defined as a view it would not be an "updatable" view because of...

Hi SQLBill,

Actually, your example would return 1,2,2 in both cases.

An example that would demonstrate WITH TIES is only slightly different:

 

SELECT TOP 2...

Tonight

Cheers,

- Mark

Vivian,

I've seen such standards documented at various sites, but not for public consumption. Why not? Beats me.

But, one SQL organisation here in Oz called SSW has a number...

Jacobe,

If you order by SALARY or SALARY ASC you'll get the lowest 5 salaries.

If you order by SALARY DESC you'll get the highest 5 salaries.

Cheers,

- Mark

I'm not quite sure of the result you want, but you could try, for starters:

 

select * from

(

    select top 5 with...

My guess is NO. Hard to find anything in BOL that states explicitly whether you can or not, but my answer is based on:

1) you can't run sp_adddistributor twice

2)...

I think you might be expecting too much of the SQL engine. YOU know that the 20 various rows just inserted will satisfy the query you subsequently execute, but...

Bobster,

UPDATE() doesn't need to be tested for each row, because it is true for the entire set. ie. the single- or multi-row update is fired by something like:

oh well, scratch that theory.

anything in the setup log/s?

Cheers,

- Mark

You're not trying to install on Win 2003 Beta, or the Web Edition are you? There's issues/restrictions with them.

Cheers,

- Mark

I think you're out of luck with BULK INSERT, whereas I believe BCP gives you the option of specifying a "discard" file.

Cheers,

- Mark

Vivian,

Rather than capturing SP_WHO output, you could go straight into sysprocesses (like SP_WHO does anyway). The following captures all current connections from "MyPC" into a temporary table #who...

How about:

 

SELECT DISTINCT , 

    (SELECT TOP 1 [office] FROM UserOfficeCount WHERE  = A. ORDER BY [count] DESC) [office]

FROM UserOfficeCount...