Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-04 : 08:15:02
|
| Mahesh writes "I am using a procedure which is using few (10) select statementsbased on 2 date parameters that i am passing to procedure.I thought performance will increase if i write views based on those 10 queriesNow the problem is that i want results in those views based on parameters that i passed to procedures.is it possible? How?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-06-04 : 08:55:21
|
| maybe you are using a materialized view in sql2k, but it doesn't sound like it....views are usually used to 1)restrict user 2)hide complex joins 3)aggregate info instead of supplying details....it is not (except with materialized views) a performance tool. on top of that, there is no way to pass a parameter to a view.now, you can create a stored proc that takes a paremeter and returns a resultset based on that parameter. maybe that is what you should look at.<O> |
 |
|
|
|
|
|
View and Parameter