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 |
|
Mess
Starting Member
2 Posts |
 Posted - 2009-05-29 : 15:50:20
|
| I have an Web Site that uses SQL 2005.Currently there is a search feature on the site (which calls a Stored Procedure) and returns the results very quickly.I have a view (vwScriptID) which contains a field called: ScriptIDI need to modify the Stored Procedure so that the results returned do not contain any records with a ScriptID that is in the view vwScriptID.I tried doing a left outer join on the view and then in the where clause I added:vwFeature.ScriptID is NullThis works, but the SP is now taking forever to run. There are only about 50 values in the vwFeature view. Is there a better way to do this? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-29 : 16:04:50
|
1. We must see the underlying table definitions2. We must see the view definition3. We must see the store procedure definition
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
View is Slowing Down My Stored Procedure