I'm not sure if this is what you are looking for, but query analyzer has the option to debug a sproc. Right click on the sproc name, choose debug...

I know this is an old thread but this is a subject which I will soon have to get into. 

I actually don't like either solution.  The multi-column table is...

A cleaner solution and an introduction to a very useful function if you've never used it.

CREATE FUNCTION dbo.LIST_OF_VALUES (@ColumnId as int)

RETURNS varchar(8000)

AS

BEGIN

 DECLARE @Items as varchar(8000)

 SELECT

  @Items = COALESCE(@Items + ','...

and don't forget db_datareader.

I'm having a similar problem.  Much smaller tables, about 6 columns, 140000 rows.  Looking at the query plan, the read from the inserted table is by far the most expensive...

Amit,

I apologize for insulting your intelligence and questioning your knowledge of sql terms.  However, based on you test data and the original question that you asked, it appears that you...

Amit,

For future reference this is called a CORRELATED SUBQUERY.  I find them to be a rather abstract thought process at first, but the only way that I know of to...