Oops! Looks like it was bad data....BRB Phil

Very cool. I'll investigate the meaning of the MAX( ... it's not obivous why it's used there.

However, using this with my REAL data (I posted only an example) I get...

Thanks to Silverfox and ALZDBA for the quick replies!

OK, if I do this am I on the right track?:

1) Manually:

Set recovery model to Full

Do a log...

Thanks for your assistance. I took Mother's day off to go feed the blackflies in Northern Ontario.

Some replies and questions:

Sorry for the difficulties downloading my code. I tried to follow...

Thanks for the encouragement.

I have attached a greatly improved version of the stored proc.

I think as you develop technical skills in a product there are typical stages including: what is...

D'oh, as Homer Simpson would say. I did not know about the Top 100%. Seems redundant, but if it works...

In a nutshell, I am tasked with rewriting a stored proc...

I'm continuing to work on this while awaiting any performance or other advice I might receive, and I now have some specific questions, observations:

-I am now in a position to...

Here are the data as attached files...

Here is the test data setup using an empty db called testing, and the stored proc.

(Data moved to attched files in another post)

I'm back. I have gone off and done my homework, hopefully, so let's restart this discussion, and I'll post my code and some test data. I have learned much while...

Sorry if I have offended the volunteers here,...

Hints on how to extract some data into, perhaps, an INSERT statement, so that it is useful to those trying to help me??

This is some data for table KTScores (for...

In the hopes that this won't be overkill, here's the stored proc I use currently.

Some notes:

The list of analyses to perform is a list of integers matching the KeyTraitNumber field...

Oh, right. You have locked the Session variable for the current user.

Does your code for lock(item) have some way of locking all Session variables of the same name inside the...

I'm not familiar with a 'lock' verb where you say you are locking the Session variable from reading by other threads... but two things: In my understanding of asp.net, there...