ขอแนวคิดเรื่องการทำ คลังสินค้า หน่อยครับ โดยมีตารางสต๊อก , ตารางใบรับสินค้า , ตารางใบเบิกสินค้า

DECLARE @Bud_GL TABLE (mm INT, yyyy INT, Bud_Amt NUMERIC(15, 4))
INSERT INTO @Bud_GL 
VALUES (1, 2015, 1), (2, 2015, 2), (3, 2015, 3), (4, 2015, 4), (5, 2015, 5), (6, 2015, 6), (7, 2015, 7), (8, 2015, 8), (8, 2016, 8), (9, 2015, 9), (10, 2015, 10), (11, 2015, 11), (12, 2015, 12), (2, 2016, 99)
SELECT *, (
		SELECT SUM(x.Bud_Amt)
		FROM @Bud_GL x
		WHERE x.mm <= z.mm
			 AND x.yyyy= z.yyyy
		) AS Bud_Amt_Cum, SUM(z.Bud_Amt) OVER (PARTITION BY (SELECT 'หอย')) Total
FROM @Bud_GL z
WHERE yyyy = 2015

   'วิ่งบน VS2010 VB.NET
    Public Shared Iterator Function LINQ_CUMM(Of TS, TR)(s As IEnumerable(Of TS), e As TR, f As Func(Of TS, TR, TR)) As IEnumerable(Of TR)
        Dim หอย As TR = e
        For Each งาม As TS In s
            Dim yRet As TR = f(งาม, หอย)
            หอย = yRet
            Yield yRet
        Next
    End Function

Private Sub Testแคมมูเลทิป()
    Dim สาว As Integer() = {1, 2, 3}
    Dim แคมมูเลทิป = LINQ_CUMM(สาว, 0, Function(i, j) i + j)
    For Each ขาวอวบ In แคมมูเลทิป
        Console.WriteLine(ขาวอวบ)
        '1, 3, 6  เอวังด้วยประการฉะนี้แลสูเอ๋ย
    Next
End Sub

--UPDATE TableA
--SET a = X.a,
---       b = X.b
--FROM (SELECT dst.id, 
--             dst.a + src.a AS a,
--             dst.b + src.b AS b
--      FROM TableA AS dst 
--      INNER JOINTableB AS src ON dst.keyField = src.keyField
--      ) X
--WHERE TableA.keyField = X.keyField

//C++ unmanage code.
#include <string.h>
int mind(char *buf, int n) {
   strncpy(buf, "Select * From Where...", n);
   return 0;
}

<DllImport>...

IN .NET

            Dim strJS As New StringBuilder()
            'Fixed bug Event Page load fired before Button Click
            '2015-02-01
            strJS.Append(" function SetTableName(tbName) {")
            strJS.Append("  $get('" & DynamicCtrl.ClientID & "').value=tbName;") 
            strJS.Append(" }")
            strJS.Append(" function LookupTab2(tabType, tabCode, event, obj1, obj2Name) {")
            strJS.Append("    var p = window.event ? event.keyCode : event.which;")
            strJS.Append("    if (p == 9 || p == 38 || p == 40 || p == 37 || p == 39 || p == 36 || p == 35) { return true; }")
            strJS.Append("        obj2 = document.getElementById(obj2Name);")
            strJS.Append("    var key = tabType + tabCode + obj1.value.toUpperCase();")
            strJS.Append("    GetBasicDataTab(key, SuccCallback, FailCallback, obj2);")
            strJS.Append(" }")
            strJS.Append(" function SuccCallback(result, obj) {")
            strJS.Append("    obj.value = result ? result : '';") 'IE-OK, FireFox-OK, Chrome-OK
            'strJS.Append("    $('#divProgressMst').hide();")
            strJS.Append(" }")
            strJS.Append(" function FailCallback(result, obj) {")
            strJS.Append("    obj.value = '';")
            'strJS.Append("    $('#divProgressMst').hide();")
            strJS.Append(" }")
            'strJS.Append("function CallServer(Args, context) { " & Page.ClientScript.GetCallbackEventReference


        txtCUR_YEAR.Attributes.Add("onkeyup", "LookupTab('GL_POST','" & SignOnBranchInfo.BrchID & "', event, this, '" & txtCUR_YEAR_Process.ClientID & "');")