Glad I could help.

To add a server to a registration group in SMO, you first make (" as New") a ServerGroup object with the name of the ServerGroup, then you make a RegisteredServer...

I think that it has to do with paging. Anchors, like page#postnumber won't...

Heh, I don't know how that happened. Thanks, Sergiy.

Sergiy: Shouldn't that be something like this?:

SELECT * FROM t_all_combination

WHERE Id IN (Select t2.Id From...

You are probably going to have to use OPENQUERY or OPENROWSET for this.

Well the version of Matt's that you have actually seems to be comparing two queries: a static version (first half), vs. a Dynamic SQL version (second half) so it's really...

Matt: this is what I posted:

Create Proc spTableRows_Window(@startingRow int, @rows int)

AS

--NOTE: some stuff stolen from Jeff Moden and Matt Miller

Select * From ExampleTable

Where LookupCol IN(

...

If this is being run from an Agent Job, then I believe that each step is wrapped in its own transaction. You would have to use your own Explicit...

Less code too.

And how can we tell the difference between debits, credits and payments?

Here is a version that gets all of the bonuses:

SELECT customerid, count (Distinct surname) AS count1

FROM tblcustomeraudit nolock

Where audituser is NULL-- bonus 3 (?)

GROUP BY customerid

Having...

Oops, I just noticed... my first one may not work on SQL 2000. Second one should be fine though.

Etiher one of these should work:

SELECT customerid, count (Distinct surname) AS count1

FROM tblcustomeraudit nolock

GROUP BY customerid

Having count (Distinct surname) > 1

And count (Distinct forname) >...

Jeff:

FYI, the "Post #" links like this do not seem to be working, they just take to the beginning of...