Thanks Seth, and you are exactly correct, I only want to insert with user and date info if the entire procedure runs error free. I can't get how to...

That was going to be my next question....

Ok, this might be a dumb question, but if I specify the physical order of the records on the insert, then why is the index so vital? If I...

Garadin the whole theory works off of using the clustered index to update the table. You *must* both create and specify this clustered index in the order that the...

Here's the link to the article I referenced. http://www.sqlservercentral.com/articles/Advanced+Querying/61716/. However, it seems to be under construction now, but I am fairly certain it described pretty well how the...

SQLMAIN, here is a temp table solution. It works by determining the previous ndt date for each record in the group, then keeping a running sum of the interval...

Well I can see one, which is that mine is limited to only one year at a time. Other than that, yours is simply...

Sherrina, not sure, but what happens if you replace your first sub query with this?

(SELECT a.name FROM agency a, ppcr_call_sheet pcs

WHERE a.agency_id=pcs.agency_id ) agency_name

Carla, the first thing I see is that unless your table only has one column, if you don't supply the column name into which you would like to insert the...

Following up on what Seth said, you could try something like the below. However, you should note that the first week will start January 1, so if your first...

shauhan13, does the letter portion of the location have any significance? If so, you could add a column to the location table to hold only the letters, which would...

Then what happens when you try location >= 'A9' ?

If you post your table structure and sample data, and your desired results based on your sample data, we will be able to help you more effectively.

Are you using Access as a front end?

Gillian, take some time and read this...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

then try to ask your question again. Its hard to know how to help you without seeing your object/data structure, and the code...