locked
How to write more values to table? RRS feed

  • Question

  • We create a ASA job, in the query we want to create a table and write some values to the table, the values is our aggregation value. 

    e.g.

    CREATE TABLE Temp (
       [Key] nvarchar(max),
       UtcTimestamp datetime,
       Value nvarchar(max)
    );

    select 'Key1' as [Key], system.timestamp as UtcTimestamp, 'value1' as Value into Temp from input 
    select 'Key2' as [Key], system.timestamp as UtcTimestamp, 'value2' as Value into Temp from input 

    but it will make an error: duplicate output names are not allowed " temp", so how to write more values into the table 'Temp' ?

    We can use the specified output only once in our query, is there anyway we can write more values to one output?


    • Edited by Jordan--23 Wednesday, June 8, 2016 7:41 AM
    Wednesday, June 8, 2016 7:40 AM

Answers