1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| INSERT INTO TpmImpHeppner
SELECT
NULL
,('C'+ CAST(substring([GL_PIECEORIGINE],12,6) AS varchar))
,'HEPP'
,01
,''
,[GPA_LIBELLE]
,''
,''
,''
,[GPA_ADRESSE2]
,''
,''
,[GPA_PAYS]
,[GPA_CODEPOSTAL]
,[GPA_VILLE]
,1
,0
,''
,''
,cast((cast(rtrim(replace([GP_TOTALPOIDSNET],'kg', '')) as float) * 1000) as varchar(50))
,'P'
,''
,''
,''
,''
,''
,''
,''
,''
,''
,''
,''
,''
FROM [SRV-SQLCGID].[CEGID].[dbo].LIGNE pl
LEFT JOIN [SRV-SQLCGID].[CEGID].[dbo].PIECE pc on pc.GP_NUMERO=GL_NUMERO AND pc.GP_SOUCHE=pl.GL_SOUCHE AND pc.GP_NATUREPIECEG=pl.GL_NATUREPIECEG AND pc.GP_INDICEG=pl.GL_INDICEG AND pl.GL_ARTICLE<>''
LEFT JOIN [SRV-SQLCGID].[CEGID].[dbo].PIECEADRESSE pa on pa.GPA_NUMERO = pc.GP_NUMERO
WHERE GL_NATUREPIECEG='BLC' AND CONVERT(Date,GP_DATEPIECE) >= CONVERT(Date,GETDATE()-1) |
Partager