just don't quote me on it remi, is all...sayonara!

nain gimon - badly written nipponese for - exactly the same reason as remi why i didn't go into this as well...

thanks - will take a look at this tonight and get back to you...

untested - but try this...not sure why you're updating with x.value when you say in your post that you want to update with x.cat ?!?!

update table2

set a = case x.cat...

salvatore - for either farrell or me (or anyone else) to see any light at all you really will have to query the 3 tables with the same date range...

I know remi and it was understandable that you got upset after all the hard work put in...however, I did post my suggestions today involving minimal changes to the existing...

well remi - then i'm glad i didn't set much store by the qualms i had when posting this about set-ting some kind of a record for nonsensical exchanges...splly. after...

yes - remi - set everyone straight on this - set a precedent/set an example and make sure that to set about solving a t-sql problem, set based solutions should...

hmm - maybe a "setup" would be ok in that context!!!

when I asked Chris for the spelling I genuinely wasn't sure if I had it right or not - I...

thanks (I think) remi - not fair to use "setup" though...implies scheming and premeditation etc.. - none of which i'm guilty of...

thx. chris - guess it wasn't typed correctly..

what is a good idea remi ?!

remi's sent you a great link...

just want to answer your questions though -

you could do a select * - except you will get your column A repeated twice...

rich - the question was how to save values...

chris - many moons ago i was in Sweden and i know they all speak excellent english - so pl. don't try...

magyar...if you want to follow the path of least resistance (meaning - use as much as you already have), then my suggestions would be:

1) Each of your tables - school,...