Skip to Content
avatar image
Former Member

bods: issue in sql transform in bods

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

capture.jpg (31.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers