$buffer =" insert into RPS.dbo.faanadep"; $buffer.=" (codemp,tipcont,cod,por,numped,numlin)"; $buffer.=" select"; $buffer.=" RPS.dbo.fapedl.codemp AS codemp"; $buffer.=" ,RPS.dbo.fapedl.tipcont AS tipcont"; $buffer.=" ,'1.'+RPS.dbo.facli.tccon+'.'+RPS.dbo.alart.tccon) AS cod"; $buffer.=" ,'100' AS por"; $buffer.=" ,RPS.dbo.fapedl.numped AS numped"; $buffer.=" ,RPS.dbo.fapedl.numlin AS numlin"; $buffer.=" from RPS.dbo.fapedl"; $buffer.=" left join RPS.dbo.facli on RPS.dbo.facli.codemp = RPS.dbo.fapedl.codemp"; $buffer.=" and RPS.dbo.facli.codcli = RPS.dbo.fapedl.codcli"; $buffer.=" left join RPS.dbo.alart on RPS.dbo.alart.codemp = RPS.dbo.fapedl.codemp"; $buffer.=" and RPS.dbo.alart.codart = RPS.dbo.fapedl.codart"; $buffer.=" where RPS.dbo.fapedl.codemp = @EMPRESA"; $buffer.=" and RPS.dbo.fapedl.numped = @NUEVONUMPED";