It does appear I do not have permissions to create a view. So your saying the only other option is to write the query as an indexed view?  

I am not sure as I have never worked with persisted column or indexed views before. Guess I would need to determine how to use each and attempt to see...

First off I want to say Thank You. It is my first time posting to a SQL forum and I am still learning, and appreciate everyones patience.

The values contained in...

Can these two pieces of code be combined into one query?

Thank you for the reply.

Do I need to change/replace anything in the code you provided?

Not sure if my last post was correct or not.

I was thinking maybe I could do some sort of Group by and then do a Count of Spc <= 2...

Ok I think I did this correct.

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

...

Thanks Craig! I will review the information.

Can this even be accomplished?

It probably can not be accomplished, but figured it was worth asking.

I do not have anything as I am even sure where to begin. I am a novice with SQL 2008 and this query is more complex.