What have you tried and how isn't it right?

Save yourself some time....we ALL...

Thanks! but it's going to be 4445 once I post this:)

There's actually two scenarios. If the view is indexed, then it essentially IS a table of sorts: the view is "materialized" as a worktable, and the results are then...

Since you're using SQL Server 2005 - use the ROW_NUMBER() function.

With some assumptions as to your column and table names, it would look like:

select Row_Number() over (partition by memberID order...

For what it's worth - using DISTINCT inside of a IN statement is just wasting cycles. You'll get the same results, and faster if you simply skip Distinct from...

Francis Yee (6/2/2008)

---

Thank you for the response.

I am telling you what I have done.

I have setup the ODBC which used a SQL user having the full dbowner rights. I could...

Michael (6/2/2008)

---

Hi Jeff.

For the sake of simplicity I used Jack's script which functionally does the same thing that I'm trying to do.

I substituted TABLOCK for TABLOCKX and still got;

Msg 308,...

michael.welcome (6/2/2008)

---

Thank you Matt.

It looks like this is a least one of the issues. I also found that temp DB is on the C: drive and is probably sharing...

Tim -

go into design on one of the linked tables in Access, then find the table properties area. You may find that it's replicated the CONTENTS of the...

I thought you were asking which columns where involved in this index? This would tell you...

John Mitchell (6/2/2008)

---

You can look in sys.indexes to find the name of the index. You can then either script the view through SSMS, or join to sys.objects to find...

james (6/2/2008)

---

As a developer just classifying yourself by what MCITP category you fall into for SQL Server should be enough. If you don't know the curricula for your role,...

And yet - per BOL - AWE exists but is completely ignored...Who's to be believed? ...

I can't say I know, but at the risk of sounding pedantic - if you have to ask the question, you should be considering a lookup table.....