insert into configuration.printout
(
[documentType], [printoutName], [jasperTemplate], [jasperTemplateSystem], [CGSTemplate], [CGSTemplateSystem], [componentName], [isDefault], [printoutHeader], [printoutFooter], [printoutLogo], [printoutFilters], [test], [printOrder], [reportFooter], [onClickHandler], [contentType], [permission], [template]
)
select
[documentType], [printoutName] +' DOJ.BEZPOŚREDNI' , [jasperTemplate], [jasperTemplateSystem], [CGSTemplate], [CGSTemplateSystem], [componentName], [isDefault], [printoutHeader], [printoutFooter], [printoutLogo], [printoutFilters], [test], [printOrder], [reportFooter], [onClickHandler], [contentType], [permission], [template]
from configuration.printout
where jasperTemplateSystem = 'OFFER_SERVICE_PL' and documentType= 'offer' and printoutName = 'oferta serwisowa'