hi all,
we are trying to use the sql server db concept of hash tables in bods sql transform.
below is a test script, it works fine when used in a script object in a bods DF, but when i use the hash tables concept inside a sql transform in bods, it gives out an error saying
"no columns found" [attached error message]

can anyone please suggest a solution to make this work?
here is a test script: [not the actual concept we are trying to implement but this is just a sample:
SET nocount ON
DECLARE @FirstTable TABLE (RandomInteger INT)
DECLARE @ii INT
BEGIN TRANSACTION
SET @ii = 0
WHILE @ii < 10
BEGIN
INSERT INTO @FirstTable VALUES (RAND() )
SET @ii = @ii + 1
END
SELECT COUNT(*) FROM @FirstTable first
go