Move your stored procedure to a function

Or write a query to do the calculation and join to the view.

Grant's explanation makes sense. It looks like you're using a temp table as well, so that will get created in tempdb along with any other intermediate tables that SQL Server...

Implicit conversions can get you in many places. The big thing to be aware of is that you'd probably want to compare > 0.0 so that the conversion doesn't take...

Maybe you can give an example with data? Not really sure what you're looking for.

Are you trying to move the structures or the diagram?

We aim to please

Both Kofi's and David's suggestions should perform well if you have the tables indexes for those columns. The query optimizer can take some shortcuts and get you quick results.

Can you post some code?

The ideas above are what I thought of. Data should be consistent and usually corruption results in pages being skipped missing data.

Those are definitely good ideas and that's a great book, but in a lot of cases I've worked on projects that couldn't be phased. Usually if that's the case, you...

For a windows alert, you can go into the services applet in control panel. Pick the SQL Server Agent service and get properties. Go to the recoveyr tab. There you...

Ed brings up a great point. Also be sure that you aren't abandoning open transactions with connecitons being held open.

I'm not sure if the .NET state changes anything on the...

It seems the second inner join isn't needed. Collapse this

/*Add the Company name for the lot numbers used in the JO*/

Select qalotc.fclot, qalotc.fcpartno, ct.fccompany

from qalotc

Join

(

...

Or if you don't need the data for other purposes, use Peter's idea, but update, then delete from temp where matching the table, then insert everything else.

I can positively, most definitely state that I am almost 100% confident that we are mostly talking about databases.

I think.

I doubt Access grows. More likely people will shift to VB.NET instead. VFP was a full featured development environment, with lots of OOP built into the product. You could develop...