Yes.

No, it will give different results. This is something simonsabin commented on in another thread. When you put a condition in the WHERE clause that references a column in the...

Well, here's a start, but somehow I don't feel it's the full solution; nevertheless, it might get you to thinking. Try using FOR XML EXPLICIT:

SELECT 1...

Do your tables have any triggers or update/delete cascading?

Matthew Burr

As a side-note, if you are using SQL 2000, you might want to look at the FOR XML clause, which you can append to queries, and which will automatically perform...

quote:

---

Unfortunately, Log Explorer is the only tool I have sen that can do this. The fact however that it can do this...

The comment about the line_id column being the only true incremental column in the table is interesting. This is not a requirement for a clustered index; i.e. a clustered index...

Yes, simonsabin is right about this. Because of this fact, I went back and rewrote my original solution to move the "Accounts.Active = 'True'" into the JOIN clause and out...

I'm surprised that GBN's solution doesn't give you errant results. Consider a situation where you have:

CREATE TABLE Customers

(Cust_Name VARCHAR(30),

 Acc_Type  VARCHAR(10),

 Location  VARCHAR(10))

I suppose what Antares said might be possible, but it seems to me more likely that statistical information on your tables is suggesting to the query optimizer that a significant...

See the "Starting SQLServerAgent Service" article in Books Online. It essentially says that the account that your SQLServerAgent service runs under needs to be a member of the sysadmin role...

I won't claim to be an expert on DMZs, but it seems to me that ports exist between your DMZ and your main domain anyway at a TCP level. I...

quote:

---

I have had similar problems like this and have used the following approach. I do not if it will work and give...