I have written an SQL view which works OK and pulls back all the data I expect, when I come to use this in a dataview all the data is not returned it just comes back blank.
Are there restrictions when writing views for dataviews on what cant be include e.g. a CTE?
