question

It's difficult to say for certain what the problem is, but I have a suggestion I'd like you to try. When you say running the query from the view returns different results than querying the view, how are you testing that? The best way would be to use a sub-select or CTE something like this: WITH vwRequest AS ( SELECT ... (view contents) ) SELECT * FROM vwRequest WHERE request = 'Request' ; If you just add the "WHERE request = 'Request'" to the view definition itself, it can sometimes return different results depending on the view definition. I'll give a simple example here. Assume a table with an Id column with values 1 through 5. CREATE TABLE #t (Id int); INSERT #t (Id) SELECT * FROM (VALUES(1),(2),(3),(4),(5)) t(Id) ; Now let's consider the following view along with the 2 SELECT statements after it. GO CREATE VIEW vwMaxId AS SELECT Id = MAX(Id) FROM #t ; GO SELECT * FROM vwMaxId WHERE Id = 3; -- filter from view SELECT Id = MAX(Id) FROM #t WHERE Id = 3; -- filter using view definition The first query won't return any rows, but the second will return one row with Id = 3. I hope this helps. Please let us know whether or not it does and if you have any further questions.