bilalhazrvi57 (5/31/2013)
That is the error which i receives"All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
"
Please check the number of columns in your SELECT's
It should be equal in all your queries that you are trying to combine in your View.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/