Urgent help needed, please - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Urgent help needed, please

Urgent help needed, please# Database - 数据库

w*i2099-12-02 08:12

1 楼

A job must done before tomorrow, please help...
we have two tables here,
table 1,
CREATE TABLE dbo.eai_inv_hdr
(
invid numeric(9,0) IDENTITY,
vendorid varchar(10) NOT NULL,
invnbr int NOT NULL,
batchid varchar(10) NOT NULL,
status varchar(1) NOT NULL
)
table2,
CREATE TABLE dbo.eai_inv_dtl
(
invamtid numeric(9,0) IDENTITY,
invid numeric(9,0) NOT NULL,
invamtcd varchar(10) NOT NULL,
invamt decimal(13,2) NOT NULL
)
table example:

w*i2099-12-02 08:12

2 楼

some explaination, the steps is:
scan all vendorid and invnbr in eai_inv_hdr table,
for those are same of v1 and i1, get their invid,
in this case, 1 and 2. then select all rows in
eai_inv_dtl table which invid are 1 and 2. then
sum the same invamcd, and put the invcmcd and
the sumed number into the destination table.
for those not has a value, put amtcd as NULL
and put amount as 0.
thanks for you guys help...

【在 w*i 的大作中提到】

: A job must done before tomorrow, please help...
: we have two tables here,
: table 1,
: CREATE TABLE dbo.eai_inv_hdr
: (
: invid numeric(9,0) IDENTITY,
: vendorid varchar(10) NOT NULL,
: invnbr int NOT NULL,
: batchid varchar(10) NOT NULL,
: status varchar(1) NOT NULL