declare @sample table ([product_id_1] int, 
						[scan_time__sec] int, 
						[focal_spot_mm] int, 
						[gray_scale_bit] int, 
						[detector_resolution_mm] int, 
						[dimension] int, 
						[image_acquisition_degree_rotation] int, 
						[source_url1] int, 
						[source_url2] int)
						
insert into @sample
select 1,2,3,4,5,6,7,8,9

select product_id_1,scan_time__sec, focal_spot_mm, gray_scale_bit from @sample
						


select ca.*
from @sample s
cross apply (
			 values
				('product_id_1',product_id_1),
				('scan_time_sec',scan_time__sec),				
				('focal_spot_mm',focal_spot_mm ),
				('gray_scale_bit',gray_scale_bit )
			) ca (colName,colValue)						


select product_id_1,ca.*
from @sample s
cross apply (
			 values
				('scan_time_sec',scan_time__sec),				
				('focal_spot_mm',focal_spot_mm ),
				('gray_scale_bit',gray_scale_bit )
			) ca (colName,colValue)