Duplicate post of

http://www.sqlservercentral.com/Forums/FindPost526429.aspx

AND

http://www.sqlservercentral.com/Forums/FindPost526428.aspx

Please don't cross post!

It doesn't matter whether you specify SYSTEM or not

From the same link

SYSTEM specifies an ANSI SQL implementation-dependent sampling method. Specifying SYSTEM is optional, but this option is the only sampling...

just to clarify, it's not that a random number of rows is returned, a random value is generated for each page of the table, and then this is used with...

grtn316 (6/27/2008)

---

I have a query like the following:

Select TableA.*, (Select sum(acres) from p_acres where p_acres.id = TableA.acre_id) As TAcres from TableA Where TAcres > 100

Order by TAcres

Here is my error:

Msg...

Jim Russell (6/27/2008)

---

I was unable to get ownership chaining to do what I needed. I finally took the cowards way out and simply moved the tables from the "other" database...

Ahh...

I was thinking much deeper!!!

Glad I culd help,

Kev

Alternatively, avoiding the IF construct....

DELETE FROM tblname WHERE type = 0 AND EXISTS (SELECT nme FROM tblName WHERE Type = 1)

How do you mean 'better'?

Kev

try looking into RANK() or ROW_NUMBER() functions.....

Kev

brendanc,

I had exactly the same scenario as you described, and I knew I had seen this issue before, but couldn't remember how I had resolved it. I had cross-db...

I'm sure I did an 'iisreset', but I'll try again and check......

Kev

so are you going to go over the exisitng records and replace the dates?

but if you use this as your default than all default dates will be stored with 00 milliseconds..

do you catch my drift??

Kev

try

convert(datetime, convert(varchar, getdate(), 120), 120)

Kev

Jonatan,

do you mean you want all the 'counts' in one record set?

select

month(a.created_date), count(e.id)

from example1 as e

where year(a.created_date) = 2008

group by

month(a.created_date)

this will give you one record set...

Gavin

you need to use parentheses i.e.

...

select top (@top)

...

Kev