Convert varchar to float, Sql Server

Language: Layout:

create table SourceTable (
    id INT,
    Column1 DATE,
    Column2 VARCHAR(50)
);
insert into SourceTable (id, Column1, Column2) values (1, '5/8/2017', '533');
insert into SourceTable (id, Column1, Column2) values (2, '10/1/2016', '988');
insert into SourceTable (id, Column1, Column2) values (3, '2/8/2016', '411');
insert into SourceTable (id, Column1, Column2) values (4, '2/29/2016', '491');
insert into SourceTable (id, Column1, Column2) values (5, '3/15/2016', '500');
insert into SourceTable (id, Column1, Column2) values (6, '4/2/2017', '677');
insert into SourceTable (id, Column1, Column2) values (7, '5/4/2016', '56/58');
insert into SourceTable (id, Column1, Column2) values (8, '8/24/2016', 'Unknown');
insert into SourceTable (id, Column1, Column2) values (9, '2/2/2017', '');
insert into SourceTable (id, Column1, Column2) values (10, '1/7/2017', '410');

create table Destination (
    id INT,
    Column1 DATE,
    Column2 float
);

insert into destination (id, column1, column2)
select id, column1, coalesce(try_cast(column2 as float),-1)
from sourcetable

select id
  , column1 = convert(char(10),column1,120)
  , column2
from Destination

View schema
Execution time: 0 sec, rows selected: 10, rows affected: 20, absolute service time: 0,17 sec