>>>>Sir view created but when I try to click on design then it display error message shown in attachment.
>>>
>>>Interesting, could be the following case:
>>>
>>>
https://stackoverflow.com/questions/28226369/i-have-a-view-that-runs-fine-when-executed-but-when-i-try-to-open-it-in-design>>
>>Yes, most of SQL Server professionals (including Erland Sommarskog) avoid using designers.
>
>When I Execute this view then it take more than 5 seconds to display data but the ROWS in both TABLES are not more than 600. So if it is possible to make this view through management studio then I think it not take more time to load.
>
>But I do not know how to do this within management studio.
>
>Please
Hi,
I didn't really read the original problem, so I don't know if proposed solution is good or not. I just commented that it's better to use T-SQL to create views and not SSMS designer which can not work with complex views.
If it's not broken, fix it until it is.
My Blog