I am having below query that will return 6 columns and i want only assign particular column (converted_skus) results to temporary table and i need to do further processing on that column only ..
I am not sure how can i assign only particular column values to temporary table where as other columns are not needed for further processing
here is my query
esitrans.pk_cert,esitrans.part_id from Clp_Active clpAct
inner join transfertable esitrans
ON clpact.pk_cert = esitrans.pk_cert
INNER JOIN pass_conversion CCM
ON esitrans.part_id = CCM.part_number
where clpAct.subscription_key = @subKey
Would any one please help on this query that would be very grateful to me.
Many thanks in advance
I am using sql server as DB