问题是这样的,我创建了一个表CostTable,专门用来放需要缴费的项目,表格式如下:
prj amount year dep
X1费 10000 1 001
X2费 5000 1 001
X3费 8000 1 002
X4费 35000 2 001
X5费 10000 2 002
X6费 10000 3 001
现在我想在查询的时候,给出year和dep,然后在一个DBGRID里面显示出如下的结果:
例如:当给出条件‘year = 1’和‘dep = 001’时,DBGRID显示如下:
X1费 X2费
10000 5000请各位大虾帮忙啊~~
prj amount year dep
X1费 10000 1 001
X2费 5000 1 001
X3费 8000 1 002
X4费 35000 2 001
X5费 10000 2 002
X6费 10000 3 001
现在我想在查询的时候,给出year和dep,然后在一个DBGRID里面显示出如下的结果:
例如:当给出条件‘year = 1’和‘dep = 001’时,DBGRID显示如下:
X1费 X2费
10000 5000请各位大虾帮忙啊~~
select @sql = 'select '
select @sql = @sql + 'sum(case prj when '''+prj+''' then amount else 0 end) as '''+prj+''' ,' from (select prj from costtable where yea=1 and dep=001 group by prj ) as aselect @sql = left(@sql,len(@sql)-1) + ' from costtable where yea=1 and dep=001 group by prj'exec(@sql)