UPDATE p_facture 
SET numeroLotDecompte='202203L001349',numeroDecompte='2791'
WHERE codePrestataire="CE1479"
AND  (LEFT(dateSysteme,10) BETWEEN '2022-03-01' AND '2022-03-31' ) 




/*UPDATE p_facture 
SET numeroLotDecompte='202108L001262',numeroDecompte='2783'
WHERE codePrestataire="CE1479"
AND  (LEFT(dateSysteme,10) BETWEEN '2021-08-01' AND '2021-08-31' ) 

UPDATE p_facture 
SET numeroLotDecompte='202109L001263',numeroDecompte='2785'
WHERE codePrestataire="CE1479"
AND  (LEFT(dateSysteme,10) BETWEEN '2021-09-01' AND '2021-09-30' ) */