Recent content by Sensei

That is correct. It's just a portion of the actual view SQL for simplicity sake. So, there are two possible outcomes from this CASE statement: Location=SameLocation (non-filtering to show all results, just like 1=1 is always true) -or- Location=SelectedLocation (exact matches only). While this...

Let's see if I'm following: Currently, I'm using views that call custom functions(which they use parameters) to look up values in a settings table to filter directly in the view (original post). More data, more stacked functions, worse performance. Are you suggesting that I create procedures...

Another forum that would rather ridicule than provide actual help. Honestly, I'd rather get no response than get the "go figure it out for yourself" response. I've used google, A LOT. I know how to use boolean search engines to get what I want, but sometimes you need a person to help guide...

Thanks for the feedback. I've been hitting a stone wall on what to do for quite some time. I still need more direction on improved methods. Basically I need information on how to: -Refresh tables (like access compact) -Properly index tables. A good article would be helpful. -How to apply...

I started using MS SQL Server about 18 months ago. It took me a while to figure out the basics. At this point, I'm ready to go "fix" some of the methods I used with better methods, with the initial intent of just improving performance. I'd like to tackle a series of reports. All of these...

Hello, Quick rundown on my related experience: -Been working with MS Access since around 1998 -Have built numerous databases from tiny half-day builds to never-ending continuous improvement databases like I am working on today -I by no means claim to be an expert. Really just a persistent hack...