Paul White NZ (3/31/2010)

---

WayneS (3/31/2010)

---

In addition to what Paul suggests (using a UNION ALL), you should remove the NOLOCK hint. Unless you don't mind sending potentially wrong data back to...

Makes me wonder what he thinks the difference is...

I still use them... strange how I don't get very many replies to the thread after doing so......

DrJogalog (3/31/2010)

---

The PK on my table is PREFIX, DOCMENT and SEQNO. This is the clustered index.

If I run this statement after clearing the SQL buffer (DBCC DROPCLEANBUFFERS) etc, it will...

Not being an Access developer, I assume that the Last function returns the last (highest) value for a field? If so, try:

select top 1 "Your Field" from "Your Table" order...

How many times can one use "dear" in a post?...

Or you might get an easier, BETTER solution if you were to provide the CREATE TABLE...

If you have three distinct queries that are run, code...

CirquedeSQLeil (3/30/2010)

---

If any are interested, I posted my blog on the topic. A greater bit of depth needs to be done with the topic. I figure this is...

K Cline (3/30/2010)

---

You're almost there. Just missing the From clause to join the tables. When I have a query with multiple tables I tend to use aliases. Personal preference, it...

I added this index: CREATE INDEX [IX_tPA_SetAuthoFunc_acFuncAbove] ON dbo.tPA_SetAuthoFunc (acFuncAbove)

I changed the CTE procedure to this:create procedure dbo.pPA_FillUserAuthorLogOn6

@nUserID ...

I might be getting deep, but after 6 hrs...

Paul White NZ (3/30/2010)

---

You are just checking server-level (login) permissions.

Write a similar query to check the database-level (user) permissions.

Use sys.database_permissions and sys.database_principals

select perm.*

from sys.database_permissions perm

...

Fellow Threadizens, if I can get you to check out this link about a sql login permission issue that I'm having, I would really appreciate it!

Thanks,

This looks like a HIPAA data feed... I sure hope you sanitized the data before uploading it here.

This should handle what you're trying to do:

-- See how this starts off...