-- TABLE variable -- pubs DB DECLARE @PkList TABLE ( seq int IDENTITY, au_id varchar(11)) DECLARE @RecCount int, @i int INSERT INTO @PkList (au_id) SELECT au_id from authors ORDER BY state, city SET @RecCount = @@ROWCOUNT DECLARE @au_fname varchar(20), @au_lname varchar(40) SET @i = 1 WHILE @i <= @RecCount BEGIN SELECT @au_fname = au.au_fname, @au_lname = au.au_lname FROM @PkList pk JOIN authors au on au.au_id = pk.au_id AND pk.seq = @i PRINT RTRIM(@au_fname) + SPACE(1) + RTRIM(@au_lname) SET @i = @i + 1 END RETURN -------------------------------------------------------------------- -- Temp Table -- pubs DB DECLARE @RecCount int, @i int SELECT IDENTITY(int) AS seq, au_id INTO #PkList FROM authors ORDER BY state, city SET @RecCount = @@ROWCOUNT DECLARE @au_fname varchar(20), @au_lname varchar(40) SET @i = 1 WHILE @i <= @RecCount BEGIN SELECT @au_fname = au.au_fname, @au_lname = au.au_lname FROM #PkList pk JOIN authors au on au.au_id = pk.au_id AND pk.seq = @i PRINT RTRIM(@au_fname) + SPACE(1) + RTRIM(@au_lname) SET @i = @i + 1 END DROP TABLE #PkList RETURN>In addition, why is it that when I am using