Dates, sadly, are not universally formatted. As Peso said, there's an ISO way of supporting dates which doesn't have the hyphens. If you want to both self-document your...

I think perhaps you've missed something here. You write a subroutine (stored procedure, function, view, etc) in SQL to interact with a specific set of tables. Passing table...

Your example of using sp_executesql is probably the best way to go about doing complex dynamic SQL queries. You build up the overall query with appropriate blocks of SQL...

You've put "Database triggers" in quotes. What do you want to accomplish? Perhaps you can get similar functionality in SQL 2000 if you let us know your goals?

Look up http://msdn2.microsoft.com/en-us/library/ms189749.aspx - you could take an application lock in a trigger on the first table and then check for the presence of that lock in the...

I think you might be making life difficult for yourself. What if you need to do row-level security in the future?

Since all non-administrators will have access only via the...

Is the SQLBrowser service running?

You wish to really join two sets of information - the start dates and the finish dates. There are numerous ways to get this information. One could be

select...

Can you post your looping code? Chances are that you're doing the delete in one BIG transaction rather than lots of little transactions.

Try something like

SET ROWCOUNT 10000

while exists(select *...

I was about to post the same thing - from a maths background you can consider null in similar ways to infinity.

Infinity <> infinity, Infinity * X = Infinity.

I think...

If you're unsure, use the GUI tools but instead of saving your changes have it save a script for you.

Hmmm - you've posted this to the wrong forum.

In any case, what do you mean by you "want" the records?

Do you want the first 5000 records to have some flag...

I second Hugo - the kludge to do ordering in a view is not something to advocate. The SQL optimiser is efficient because it doesn't guarantee an order unless...

Dragon_sv's way should give you what you want. Make sure you have an appropriate index! 🙂

I've never worked with that product. Could you post some of the table structure? Can your client application work with MS SQL Server instead of MS Access?

I'd suggest...