sql - INSERT INTO table Column and Value -

just quick question . possible select column , custom value table. have table of software , table of installed software. i'm using domain role value of machine installed on specify software type of server or pc. there multiple types of server , pc , distill these values 1 numerical value can linked table. example result be

¦softwarename¦softwaretype¦     ¦domainroleid¦type  ¦ ¦sofware1    ¦1           ¦     ¦1           ¦pc    ¦ ¦sofware2    ¦2           ¦     ¦2           ¦server¦ ¦sofware3    ¦1           ¦ ¦sofware4    ¦2           ¦ 

as need select multiple records table , insert different type value wondering if during insert clause like

insert tblsoftware (softwarename, softwaretype) select (softwarename, '2') tbl2 domainrole > 1 

is possible or need perform update after data over? in advance!

try -

insert tblsoftware (softwarename, softwaretype) select        softwarename      , case when type = 'pc'            1            else '2'        end type tbl2 domainrole > 1