Have tried out suggested list of books and working through them.

Thanks for the advice

It wil be for performance

Hi Luis

Yes I now understand this thank you.

Allan

Luis

Thats exactly what I want, thank you.

Allan

Phil's solution sorted it out thanks

Great I now have the solution. Many thanks to you all.

Thankyou for you reply.

grps can be updated many times on many dates, so can appear in the table many times.

The table is ordered by date, so I am only interested...

Perhaps I should have said that I'm trying to prevent sql insertions.

Is a stored procedure with parameters sufficient to prevent all sql insertions? In this instance, is sp_executesql with...

Many thanks, I've been looking at options for avoiding sql insert when inserting a new row to a table. I want to use sp_executesql with parameters and wasnt sure how...

Jeff

Thanks for the help,

I had already used a cursor but was looking for a more elegant solution.

What I didnt tell you, (for ease of example) is that each line...