In the example given, @parameterID holds a list of IDs in sequence and there is no break in the sequence.

Could you resolve your issue by finding Categorys between the first...

I have a couple of observations from the postings you have already made.

1)Is this question more about the form than the database...

E.g.

I am calling up my holiday list and am...

Are you saying that you want a single table that holds

TableName, DateLastModified

If so, then one way would be to add a trigger to every table that you require to be...

Sorry, I'm not sure I understand what is being asked for

Is the question about how to get the records into the table or about how to get a sum for...

I would say that a lot of 'mature' systems that were written on earl(ier) SQL compliant platforms will not include relationships or constraint parameters.

Referential integrity in the database is not...

This kept me awake half the night - I knew it shouldn't be too difficult. (would have been a nightmare in SQL2000)

If you were to put this in a production...

Would I be correct in thinking that these are reconciliation groups?

If you have 3 receipts and 10 invoices with cross associations in the reconciliation they all need to be in...