When do an insert to a temp table is it possible to insert variables that does not really exist in the "select" statement.In this case I would like to insert a value for plant_id and plant_name even if they do not exist in the salestkt table. I cannot use a default value since I am looping through 8 different data bases and manually need to control values plant variables.create table #PlantTable ( plant_id char(10) default ' ', plant_name char(20) default Null, shift_date varchar(25) default Null, outside_qty decimal(15,2) default Null, intercompany_qty decimal(15,2) default Null )Insert Into #PlantTable(shift_date, intercompany_qty, outside_qty)SELECT * FROM OPENQUERY(ADS_RGDB_SERVER, 'SELECT CONVERT(MAX(shift_started), SQL_VARCHAR) as shift_date, SUM(CASE WHEN customer = ''35'' THEN net ELSE 0 END) AS intercompany_qty, SUM(CASE WHEN customer <> ''35'' THEN net ELSE 0 END) AS outside_qty FROM salestkt WHERE (void is null or void = false) and incoming_material = false and shift_started = (SELECT MAX(STK.shift_started) as shift FROM salestkt AS STK WHERE EXISTS(SELECT * FROM SHFTDATE AS SD WHERE SD.shift_started is not Null and SD.shift_started = STK.shift_started))')
[Resolved] Insert variables not part of my select
Posted - 2010-06-22 : 08:10:22
