http://sql.ru/forum/actualthread.aspx?tid=484619&hl=iscala
Спроси на специализированном форуме.
И сразу определись, что такое инвойсы... Вот у поставщиков энто тож так называется...


INSERT INTO dbo.#Payable
([Supplier Code], [Supplier Name], [Invoice №], TransactioNo, Account,
[invoice amount], BookEntrDate,
[Days Invoice], [Days Overdue], AmLocalCurr, XZ,
CurrencyCode, last_Cur, INN, IBU, CostCenter, Project, InvDate)
SELECT
a.PL01001 AS [Supplier Code], a.PL01002 AS [Supplier Name],
b.PL03002 AS [Invoice №], b.PL03003 AS TransactioNo,
LEFT(b.PL03017, 8) AS Account,
b.PL03014 AS [invoice amount], b.PL03005 AS BookEntrDate,
DATEDIFF(day, b.PL03005, '''+cast(@DateFrom as varchar)+''' ) AS [Days Invoice],
DATEDIFF(day, b.PL03006, '''+cast(@DateFrom as varchar)+''' ) AS [Days Overdue],
SUM(c.PL21009) AS AmLocalCurr,
b.PL03014 - SUM(ISNULL(c.PL21009, 0)) AS XZ, b.PL03015 AS CurrencyCode,
dbo.FATK_DateCURR('''+cast(@DateFrom as varchar)+''' , b.PL03015) AS last_Cur, a.PL01025 AS INN,
SUBSTRING(b.PL03017, 13, 3) AS IBU, SUBSTRING(a.PL01021, 9, 4)
AS CostCenter, SUBSTRING(b.PL03017, 16, 8) AS Project, b.PL03004 AS InvDate
FROM dbo.'+@PL01+' a INNER JOIN
dbo.'+@PL03+' b ON a.PL01001 = b.PL03001 LEFT OUTER JOIN
dbo.'+@PL21+' c ON b.PL03001 = c.PL21001 AND b.PL03002 = c.PL21002

WHERE

(b.PL03005 <= '''+cast(@DateFrom as varchar)+''' )
AND (ISNULL(c.PL21007, 0) <= '''+cast(@DateFrom as varchar)+''' )
AND (NOT (LEFT(b.PL03017, 8) LIKE ''62181%''))
AND (NOT (LEFT(b.PL03017, 8) LIKE ''6419100%''))
AND (NOT (LEFT(b.PL03017, 2) IN (''71'', ''73'')))
AND (NOT (c.PL21005 IN
(SELECT GL06002
FROM dbo.'+@GL06+'
WHERE (GL06003 >'''+cast(@DateFrom as varchar)+''' ))) OR
c.PL21005 IS NULL)
GROUP BY
a.PL01001, a.PL01002, b.PL03002, b.PL03014,
DATEDIFF(day, b.PL03006, '''+cast(@DateFrom as varchar)+''' ),
b.PL03015, dbo.FATK_DateCURR('''+cast(@DateFrom as varchar)+''' ,
b.PL03015), a.PL01025, LEFT(b.PL03017, 8), b.PL03017, b.PL03005,
DATEDIFF(day, b.PL03005, '''+cast(@DateFrom as varchar)+''' ), SUBSTRING(b.PL03017, 13, 3),
SUBSTRING(a.PL01021, 9, 4), SUBSTRING(b.PL03017, 16, 8), b.PL03003,
b.PL03004
HAVING
(b.PL03014 - SUM(ISNULL(c.PL21009, 0)) <> 0)