Post reply

Temporary tables in Transformation

  • October 14, 2004 at 1:33 pm

    #59627

    Can I use temporary table in transformation?

  • October 17, 2004 at 8:26 am

    #526987

    hey riga

    its really a interesting question...

    i dont think u can do that once the scope of the temp rable is over. u please do let me know the actual answer.

    thanx,

    Rajiv.

  • October 20, 2004 at 9:58 am

    #527335

    Use a derived table:

    select a.f1, a.f2

    from myTable a

    inner join

    (select f1 from myOtherTable)myDerivedTable

    on a.f1 = myDerivedTable.f1

    [font="Courier New"]ZenDada[/font]

  • October 20, 2004 at 11:54 am

    #527346

    You can if you use a stored procedure instead of inline SQL.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply