关于glpost的讨论汇总 - 话题女王

B********r
发帖数: 16

来自主题: Computation版 - SQL 问题

我是会计，请教版上各位科技牛人一些初级问题，请大家轻拍。
我前任设计了一个EXCEL SHEET，连接到ACCOUNTING DATABASE，从DATABASE的TABLE中
提取出有用的DATA。我们现有系统中带的REPORTS很少，格式也不好用。他设计的EXCEL
可以让我的工作快数倍。
CONNECTION STRING:
DSN=AUNC;ServerName=BETS-LPC11.1583;ServerDSN=AUNC;ArrayFetchOn=1;
ArrayBufferSize=8;TransportHint=TCP;ClientVersion=10.30.017.000;
CodePageConvert=1252;PvClientEncoding=CP1252;PvServerEncoding=CP1252;
AutoDoubleQuote=0;
COMMAND TEXT:
SELECT GLAMF.ACCTID, GLAMF.ACCTDESC, GLAMF.ACCTTYPE, Sum(GLPOST.TRANSAMT) AS
'Sum of TRANSAMT'
FRO... 阅读全帖

S*******u
发帖数: 727

来自主题: Computation版 - SQL 问题

UNC.GLAMF GLAME , AUNC.GLPOST GLPOST
THESE ARE tables: one GLAME- I guess this the general leger about the amount
. The other one is GLPOST, i guess this is the general leger posted.
ClientVersion=10.30.017.000; I guess your company is using Microsoft SQL
Server 2008R2.
SERVER的名字:ServerName=BETS-LPC11.1583
DSN=AUNC.
Just my understanding, it might be wrong. 我不是计算机出生, 只懂些皮毛.
But you need to let me know whether my understanding is correct.

#	版面	帖数(主题数)
-	全站	4871 (796)
1	Military	3777 (569)
2	Stock	341 (51)
3	Joke	117 (17)
4	History	116 (3)
5	Automobile	100 (9)
6	USANews	55 (9)
7	Midlife	45 (1)
8	Headline	41 (41)
9	Dreamer	33 (13)
10	FleaMarket	32 (20)
11	Living	30 (7)

版面

帖数(主题数)

全站

4871 (796)

3777 (569)

341 (51)

117 (17)

116 (3)