USE master;  
GO
IF DB_ID ( 'qSetner' ) IS NOT NULL
DROP DATABASE qSetner;
GO
CREATE DATABASE qSetner; 
GO
USE qSetner;




CREATE TABLE Qoob (
	QoobId			INT IDENTITY PRIMARY KEY,
	QoobProj		INT
);

Insert into Qoob values (1)

GO

CREATE PROC myFoo
AS
BEGIN

	CREATE TABLE #heh
	(
		one INT,
		two INT
	)
	
	CREATE TABLE #moon
	(
		TProj INT
	)
	
	INSERT INTO #moon VALUES (1)
	INSERT INTO #moon VALUES (2)
	

	DECLARE @QProj INT
	DECLARE @QoobFound INT	
	DECLARE test_cur CURSOR FOR 
	SELECT TProj FROM #moon
	OPEN test_cur
	FETCH NEXT FROM test_cur INTO @QProj
	WHILE @@FETCH_STATUS = 0
	BEGIN
	
		SELECT @QoobFound = QoobId FROM Qoob WHERE (QoobProj = @QProj)
		
		INSERT INTO #heh VALUES (@QoobFound, @QProj)
		
		FETCH NEXT FROM test_cur INTO @QProj
		
	END
	
	CLOSE test_cur
	DEALLOCATE test_cur
	
	select * from #heh
	
END
GO


EXEC MyFoo
GO