I am not sure why you are doing a join on the software table if you already know the four values you want to insert, however, the query I gave...

--===== Create the test table with CREATE TABLE #software

(

SoftwareID ...