Hi, This is a post contrary to the information I have read in this post so please don't take exception.

I have a SQL Express 2008 server that is read from...

Thanks for the confirmation. I reached the conclusion after trial and error that a long query with all elenments within the select statment was faster than an beautifully written one...

Unlike the MAC household I am working weekends... but this one deserves some further input.

Working with dates and times is straight-forward but what I am reading is the date/time data...

The READUNCOMMITTED will percolate down to all select statements against the view. You don't need to be explicit.

However - be careful you have not set OPTION READCOMMITTED at the top...

This works:

I took the SSquared recommendation to use sp_procoption (starts when master db initialises) and configured SQL Express to start my procedure on start-up:

EXEC master.dbo.sp_procoption @ProcName = 'recDataControl_Loop', @OptionName...

Thanks GSsquared - the StartUp script is a fine idea but has the short-coming. Without Agent to keep restarting it if anything fails there is nothing in Express that can...

Thanks to all the replies but I think my logic and reasoning is the opposite to normal programming. I live inside SQL and only write or use outside programs when...