最新评论
Jaguar_Jacky 2010-09-14 16:17
楼主还是看看下面这个地址吧
http://www.cnblogs.com/shaoming01/archive/2010/09/09/shaoming01.html
lhjhl 2010-09-13 16:48
@木鱼
http://download.csdn.net/source/644246
http://download.csdn.net/source/625079
开发快车最新版DXperience_8.2.4_Sources 源程序代码
资源大小： 30.33MB
资源类型：
发布人： JLKEngine001
发布日期： 2008-09-23 17:01
Tag： DXperience 8.2.4
资源分： 10
下载人数： 19
////////////////////
以上引自csdn
dev:develop 开发
express: 可以表示快车, 快递，快速 的意思。
所以我们私下叫它开发快车，或许每个地方有不同的说法吧。
OC Life 2010-06-01 21:14
几年前和新科的一起做过市公安局的3警合1项目，当时他们主要做公安接处警系统，用vb开发
rad 2009-04-07 18:57
Cien 2009-03-24 18:12
declare @id int ,@count int
set @id = 1
select @count = max(id) from tbExcel
create table #tt(t_id int,t_value int,t_name nvarchar(50))
while(@id <= @count)
begin
insert into #tt select @id as t_id,(select sum(value) from tbExcel where id = @id) as t_value,
(select name from tbExcel where value in (select max(value) from tbExcel where id = @id) and id = @id) as t_name
set @id = @id + 1
end
select distinct * from #tt order by t_id
drop table #tt
set @id = 1
select @count = max(id) from tbExcel
create table #tt(t_id int,t_value int,t_name nvarchar(50))
while(@id <= @count)
begin
insert into #tt select @id as t_id,(select sum(value) from tbExcel where id = @id) as t_value,
(select name from tbExcel where value in (select max(value) from tbExcel where id = @id) and id = @id) as t_name
set @id = @id + 1
end
select distinct * from #tt order by t_id
drop table #tt
loworth 2009-03-24 17:51
/*构造表*/
CREATE TABLE TEST1
(
ID INT,
value INT,
[NAME] VARCHAR(10)
)
GO
/*填入数据*/
INSERT INTO TEST1 ( ID, value, [NAME] )
SELECT 1,
100,
'liyu'
UNION ALL
SELECT 1,
200,
'sula'
UNION ALL
SELECT 2,
300,
'lily'
UNION ALL
SELECT 2,
400,
'yumei'
UNION ALL
SELECT 3,
300,
'meili'
UNION ALL
SELECT 3,
200,
'hehe'
GO
/*原有数据*/
SELECT *
FROM TEST1
/*
ID value NAME
----------- ----------- ----------
1 100 liyu
1 200 sula
2 300 lily
2 400 yumei
3 300 meili
3 200 hehe
(6 行受影响)*/
/*查询*/
SELECT test1.id,
SUM(test1.value),
tmain.name
FROM test1
JOIN test1 tMain ON test1.id = tmain.id
WHERE NOT EXISTS ( SELECT 1
FROM test1 tSub
WHERE tMain.id = tSub.id
AND tMain.value < tsub.value )
GROUP BY test1.id,
tmain.name
ORDER BY test1.id
/*
id name
----------- ----------- ----------
1 300 sula
2 700 yumei
3 500 meili
(3 行受影响)*/
GO
/*销毁表*/
DROP TABLE TEST1
CREATE TABLE TEST1
(
ID INT,
value INT,
[NAME] VARCHAR(10)
)
GO
/*填入数据*/
INSERT INTO TEST1 ( ID, value, [NAME] )
SELECT 1,
100,
'liyu'
UNION ALL
SELECT 1,
200,
'sula'
UNION ALL
SELECT 2,
300,
'lily'
UNION ALL
SELECT 2,
400,
'yumei'
UNION ALL
SELECT 3,
300,
'meili'
UNION ALL
SELECT 3,
200,
'hehe'
GO
/*原有数据*/
SELECT *
FROM TEST1
/*
ID value NAME
----------- ----------- ----------
1 100 liyu
1 200 sula
2 300 lily
2 400 yumei
3 300 meili
3 200 hehe
(6 行受影响)*/
/*查询*/
SELECT test1.id,
SUM(test1.value),
tmain.name
FROM test1
JOIN test1 tMain ON test1.id = tmain.id
WHERE NOT EXISTS ( SELECT 1
FROM test1 tSub
WHERE tMain.id = tSub.id
AND tMain.value < tsub.value )
GROUP BY test1.id,
tmain.name
ORDER BY test1.id
/*
id name
----------- ----------- ----------
1 300 sula
2 700 yumei
3 500 meili
(3 行受影响)*/
GO
/*销毁表*/
DROP TABLE TEST1