In 2005 - you can emulate a uniqueID with the ROW_NUMBER() predicate.

hmm...kind of looks to me that there's a combination of several things of code. One of which is the beginning to dynamically build the statement (based on whatever happens...

Matt -

In your case - "Rownum" would be whatever you're using to sort your dataset (preferrably indexed if you want any kind of performance , ideally the clustered index)....

Something isn't right, because the Return you're using there shouldn't be accepting a value. Where's the rest of the code?

I'd guess that something is causing the update to fail,...

Lynn (5/1/2008)

---

Just to clarify, the issue only applies to my dev, qa and uat environments, not production.

Option 2 is my backup plan. However, I was interested in implementing option...

Permissions....

Does the SQL Server service account have permissions to that share on the remote machine?

Alternatively - does the account running the query have read perms on master..syslogins?

speaking of dupes...

methinks we've all been duped into continuing to beat up on this topic, since the OP is long gone...:)

It used to be that Hubs were cheaper, so there was a price point advantage. High-end switches are still quite a bit more expensive.

On the low end - the...

Cache is an "object database" (meaning dimensional/hierarchical, NOT relational). Probably gets away with it based on the fact that it's in its own class. Nothing else equivalent to...

RyanRandall (5/1/2008)

---

I knew I'd get that...

John Rowan (4/30/2008)

---

Thanks for picking this one up Matt. I think I messed with the query just before posting it becuase I had the COUNT(*) included when I was...

kmerkle (4/30/2008)

---

You're absolutely right. In the big scheme of things this means diddly. However, the PartnerID appears on reports, etc. and the customer doesn't like it. ...

In access - it could be something as simple as starting to type in a form, and hitting cancel...

In SQL Server - things like SET IDENTITY_INSERT ON could easily help...

If you really only want one row - use Jack's solution, but change it to state SELECT TOP 1, as in

SELECT Top 1

Fl.folderId

ISNULL(COUNT(EL.eventTargetId), 0)...

You want to encapsulate the grouped count in a sub-query, and THEN run the MAX against the derived results of the sub-query. Or - depending on exactly what you're...