Sure I understand that indexes are against tables. And I understand the difference between clustered and non-clustered indexes. My question is will non-clustered indexes perform better if there is a...

Thank you

Sorry, SQL Compare.

A tool we can use to make sure our Development,...

mickyT (2/13/2013)

---

There are a number of ways of doing this. Here's a few ways of writing essentially the same query.

SELECT completed, auditdate, a.agentNumber

FROM tblAudit_AuditSchedule a

INNER JOIN (

SELECT agentNumber, MAX(auditdate)...

Animal Magic (2/13/2013)

---

infact looking again at your post you dont even need a HAVING clause. you just need the max

select Max(auditDate) from tblAudit_AuditSchedule where agentNumber = '54321'

if you need...

And thanks for the help by the way. Much appreciated.

Let me explain it a little bit better. Every agentNumber will have dozens of audits, so for example:

agentNumber auditdate completed

54321 ...

SQL told me I couldn't have auditdate in the HAVING CLAUSE without it being in the GROUP BY CLAUSE which is the only reason I added it. And the MAX(auditdate)...

Ok looking at the Event Viewer I see it is trying to use the anonymous IIS account from the web server to access the folder and doesn't have rights. Any...

We had an existing ReportServices set up on one server that we needed...

Thanks for all the help guys, that sorted me right out.

Thanks for the advice, but I'm confused on where I am supposed...

SQLKnowItAll (12/26/2012)

---

If it is as simple as what you provided... creating an index on Table2.FieldB will "probably" help. It will get rid of the scan and use a key...

Thanks

GilaMonster (12/26/2012)

---

Maybe, depends what's in the select clause,...