Wow! Thanks!

CSDunn

David,

Thanks a ton for your help and patients, I really appreciate it!

CSDunn

Greg,

Yes, please provide samples.

Thank you for your help!

CSDunn

Thanks for this idea. With this idea, I would need to set up MAX(CASE.. for 662 teachers in order to satisfy any combination of the Location2 and Grade parameters. At...

I will present more detail on this issue shortly. Thanks!

CSDunn

Thanks for the suggestion. Do you have an example of this? I have not done Lookup Tables in SQL Server 2000.

CSDunn

Actually, it just occured to me to subtract the CHARINDEX from the LEN of the data:

Left(T1,Len(T1) - CharIndex(' ',Reverse(T1),1))as NameData

CSDunn

Thanks, I will look into this.

CSDunn

Thank you all for your help!

CSDunn

Thanks for your help!

CSDunn

Thanks for your help. It didn't occur to me that ambiguity could be a problem for fields used in the Order By clause if matching field names are used in...

Thanks! I thought that Truncating the table should work, but it did not occur to me at the time to sort by my IDENTITY column after the new data went...

Right there in front of me, of course.

Thanks!

CSDunn

Do you have any good SQL Code reference books that you would recommend? I find it hard to locate stuff like this in BOL.

Thanks!

CSDunn

Thanks again!

CSDunn