hi,what would be the fastest way (in terms of reads) to add missing rows.sample data:drop table test;gocreate table test(id int identity(1,1),num int,name char(10))insert into testselect 1, 'jane' union allselect 5, 'jane' union allselect 12, 'tom' union allselect 36, 'jeff' union allselect 42, 'jeff'
and desired output:num name1 jane2 jane3 jane4 jane5 jane12 tom36 jeff37 jeff38 jeff39 jeff40 jeff41 jeff42 jeffthank you