اضافة صغيرة SELECT PERCENT dbo.PM20000.VENDORID, dbo.PM00200.VENDNAME, dbo.PM20000.DOCTYPE, dbo.PM20000.DOCDATE, dbo.PM20000.DOCNUMBR, dbo.PM20000.DOCAMNT, dbo.PM20000.VCHRNMBR, dbo.PM20000.CURNCYID, dbo.PM20000.TRXDSCRN, CASE WHEN dbo.PM20000.DOCTYPE < 5 AND dbo.PM20000.DOCDATE = '12/31/2007' THEN dbo.PM20000.DOCAMNT ELSE 0 END AS fcrdt, CASE WHEN dbo.PM20000.DOCTYPE < 5 THEN dbo.PM20000.DOCAMNT ELSE 0 END AS crdt, CASE WHEN dbo.PM20000.DOCTYPE > 4 AND dbo.PM20000.DOCDATE = '12/31/2007' THEN dbo.PM20000.DOCAMNT ELSE 0 END AS fdebt, CASE WHEN dbo.PM20000.DOCTYPE > 4 THEN dbo.PM20000.DOCAMNT ELSE 0 END AS debt, dbo.PM00200.VNDCLSID FROM dbo.PM00200 INNER JOIN dbo.PM20000 ON dbo.PM00200.VENDORID = dbo.PM20000.VENDORID ORDER BY dbo.PM00200.VENDORID __________________ هذا الموضوع عبارة عن بذرة تحتاج للنمو والتحسين؛ فساهم في إثرائه بالمشاركة فيه [LEFT]Best Regards Ahmed Ibrahim I.T Manager http://ahmedibrahim.net Mobile: +2 010-3438385 Microsoft Certified Business Management Solutions Specialist for Microsoft Dynamics AX 2009,Dynamics CRM4,GP10 Microsoft Certified Business Management Solutions Professional Applications for Microsoft Dynamics GP10 MCTS: SQL Server 2005,Windows SharePoint Services 3.0 ITIL Foundation V3 |