AnsweredAssumed Answered

Creating temp table in sql database thru boomi

Question asked by dsy on Sep 18, 2017

I have a need to create temporary table in the database. I have the query working when connecting directly to the database. How can I achieve retrieving the same data when using boomi. I have a sql server database.


-- create temporary table to store downline values we're tracking (upline is cids specified above) 
IF OBJECT_ID('tempdb.dbo.#ExtractDownline', 'U') IS NOT NULL DROP TABLE #ExtractDownline; 
CREATE TABLE #ExtractDownline ( 
RowIndex NUMERIC(18,0) NOT NULL IDENTITY(1, 1), 
BeeBusinessGuid NUMERIC(29,0) NOT NULL, 
CREATE CLUSTERED INDEX #ExtractDownlineI1 ON #ExtractDownline (BeeBusinessGuid) 

--- Query below to insert to #ExtractDownline