Thanks for the BOL reference. oh great. They recommend you that "...SET @local_variable be used for variable assignment rather than SELECT @local_variable..." but they don't really tell you...

thanks

however, BOL only says you can't use INSERT INTO but it didn't say that you can't use INSERT. I wonder if there is another way.

Billy

Edited by - billy_pang on...