21-05-17, 09:05 PM
طيب وهذا الإستعلام ؟
declare @UM Int
set @UM Int = (SELECT dbo.Facture_L.UM FROM dbo.Facture_L)
if @Um = '1' then SELECT dbo.Facture_L.Num_Vent, dbo.Facture_L.Num_Fact_Vent, dbo.Facture_L.ID_Prod, dbo.Facture_L.UM, dbo.UM.Nom_UM, Facture_L.Qte_V * 0.02 AS Qte
FROM dbo.Facture_L INNER JOIN
dbo.UM ON dbo.Facture_L.UM = dbo.UM.ID_UM
بتطلع لي هذه الرسالة :
declare @UM Int
set @UM Int = (SELECT dbo.Facture_L.UM FROM dbo.Facture_L)
if @Um = '1' then SELECT dbo.Facture_L.Num_Vent, dbo.Facture_L.Num_Fact_Vent, dbo.Facture_L.ID_Prod, dbo.Facture_L.UM, dbo.UM.Nom_UM, Facture_L.Qte_V * 0.02 AS Qte
FROM dbo.Facture_L INNER JOIN
dbo.UM ON dbo.Facture_L.UM = dbo.UM.ID_UM
بتطلع لي هذه الرسالة :