I have an SP which does an insertion and a select on the same table, like this.. INSERT INT) table1 ... ...
social.msdn.microsoft.com