How to call the two views
I have a two parameterised views first call one view after call the second view with first view result please give me examples
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Nov 12, 2013, 1:48 AM
hi,
SQL View behave like virtual table that contain the query.
this can be also achieve by using User define function or stored procedure.
Please refer
http://msdn.microsoft.com/en-us/library/c11kd98s(v=vs.80).aspx
hope this will help you.
Jaganathan BantheswaranPosted Nov 12, 2013, 12:05 AM
You can't create parameterized views in sql server 2008. You have to use SP instead of Views.