stanl
12-27-2015, 06:25 AM
I have an Access SELECT INTO... query that creates a temporary table, with all but 2 fields derived from MYSQL data. The 2 fields are created as numeric placeholders to be filled in with a join on another query from SQL Server.
SELECT INTO [table] 0 as placeholder1, 0 as placeholder2.... works but the fields are created as long integers. I tried 1*0.00000 and both still cam out as longs. I need them to be created as double as the SQL Server data has 5 decimal places.
[oops just saw my mistake.... please ignore]
SELECT INTO [table] 0 as placeholder1, 0 as placeholder2.... works but the fields are created as long integers. I tried 1*0.00000 and both still cam out as longs. I need them to be created as double as the SQL Server data has 5 decimal places.
[oops just saw my mistake.... please ignore]