Server: Msg 4414, Level 16, State 1

[EricVonSkip]

Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (256) was exceeded.

What I am trying to do is build multiple views that I can then join together to build one large data pull.

So far I have two views in the final select.

Each of these final views each call five views.

When I go back and run the views individually they run successfully its when I join them together that I get the error.

 

[JayKusch]

How many tables does each view use?

Thanks

J. Kusch

 

[EricVonSkip]

Each View uses about 10 tables. I believe that I have found another way to go. I am just going to create one proceedure that will do everything that I need and use a union at the end.

 

[Lightning]

I've just run up against this same problem. Did you ever resolve this?

Lightning

 

[EricVonSkip]

I went with a stored procedure to do everything.