VUE SQL SERVER
Bonjour,
dans les vue pourquoi on utilise le "@" comme dans la vue ci dessous
SELECT FACTURE_VENTE_ENT_V.COMMERCIAL1,
FACTURE_VENTE_ENT_V.COMMERCIAL1NOM AS NOM,
FACTURE_VENTE_ENT_V.MONTANTSIGNE_DEV AS MtFactureSign,
FACTURE_VENTE_ENT_V.DOSSIER,
FACTURE_VENTE_ENT_V.DATEPIECE
FROM FACTURE_VENTE_ENT_V
WHERE Year(FACTURE_VENTE_ENT_V.DATEPIECE) BETWEEN ( @ANNEE - 1 ) AND @ANNEE
AND FACTURE_VENTE_ENT_V.DOSSIER = @DOSSIER
AND ('NOETB' in (@ETB) or FACTURE_VENTE_ENT_V.ETABLISSEMENT IN (@ETB) )
ORDER BY FACTURE_VENTE_ENT_V.MONTANTSIGNE_DEV DESC
dans les vue pourquoi on utilise le "@" comme dans la vue ci dessous
SELECT FACTURE_VENTE_ENT_V.COMMERCIAL1,
FACTURE_VENTE_ENT_V.COMMERCIAL1NOM AS NOM,
FACTURE_VENTE_ENT_V.MONTANTSIGNE_DEV AS MtFactureSign,
FACTURE_VENTE_ENT_V.DOSSIER,
FACTURE_VENTE_ENT_V.DATEPIECE
FROM FACTURE_VENTE_ENT_V
WHERE Year(FACTURE_VENTE_ENT_V.DATEPIECE) BETWEEN ( @ANNEE - 1 ) AND @ANNEE
AND FACTURE_VENTE_ENT_V.DOSSIER = @DOSSIER
AND ('NOETB' in (@ETB) or FACTURE_VENTE_ENT_V.ETABLISSEMENT IN (@ETB) )
ORDER BY FACTURE_VENTE_ENT_V.MONTANTSIGNE_DEV DESC