>>>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