Alvin, did you lose your tin-foil hat again?? You know we are supposed to be able to read minds. 😉

I don't believe this is possible. However, if the user does not have permission, they won't be able to access the other databases.

Looking at the query and the fact that it uses just that one column, I'd add an index on that column. If it has to do a table scan...

select distinct

a.EMPID,

sdate

into

#temp1

from

dbo.vwJobcd as a

inner join #tabdates as b

...

I'd also make the following change to your where clause so that the Query Optimizer can make use of an index on meetingstartdate if it exists.

SELECT

meetingstartdate,

...

Roy Ernest (7/28/2009)

---

john.arnott (7/28/2009)

---

Just be careful of starting an internecine battle. There are more of...

Yes it is possible. I would not suggest it.

Andrew Collins (7/28/2009)

---

Does anyone know how much this costs? i cant seem to find a price anywhere (UK Price)

Do you need a separate license for a passive node on a...

Thank you, Lutz.

Well, it is now official. We are down one daughter in our household.

Kassondra is now on her way to Fort Jackson in South Carolina to start her military career...

michael vessey (7/27/2009)

---

ok - let me be clear

the original post indicated that i wanted an Efficient method of getting the max value from Rown_number()

but the query inside the CTE/subquery...

Here is part of your problem, your code:

CASE

WHEN @ProgramCode = '01' AND

@CovII >...

Based on the original sample using only one table, yes, your requirements changed.

Going to more complex queries, it may have helped to show that instead of a single table query,...

Hima Bindu Nagisetty (7/26/2009)

---

It looks like indexed views do use their index without NOEXPAND option on Developer edition too.. Please try below test script.

The execution plans for last two statements...

Because, WS_Job_Number is defined as [char](17) and ProjectId is defined as an int, therefore I wanted...