select Sum(1) as GroupNo ,VENDOR_NO ,ITEM_NO ,RECIVE_DATE , QTYfrom Tablewhere....
group by VENDOR_NO ,ITEM_NO,RECIVE_DATE ,QTY
group by VENDOR_NO ,ITEM_NO,RECIVE_DATE ,QTY
解决方案 »
- 循环保存的问题
- 请问 除了用 主键 可以 防止 每行 的数据 相同内容 , 还有什么 方法 可以 防止 每行 的数据 内容相同 ????
- SQL SERVER 2008 如何让执行计划提示缺少索引
- 疑难问题《关于数据库重备份文件恢复的问题》
- 数字转成成日期格式
- 数据库初学者
- 满分100求一个考勤计算问题~谢谢
- 低级问题,一个sql的存储过程怎么写??定时导入的?详细请进
- 想知道有关数据库调用效率的资料
- 如何从考勤数据抓取出每个人每天的两条有效考勤数据(上班、下班)
- 开发一个远程访问SQL Server的程序(VC),需要做什么工作?
- 数据访问技术的演变--毕业设计要翻译的东西,时间紧,马马虎虎的,给看看改改啊
INTO #TEMPTABLE
FROM TABLENAME
ORDER BY VENDOR_NO,RECIVE_DATESELECT COUNT_NO-MIN_COUNT_NO+1,VENDOR_NO,ITEM_NO,RECIVE_DATE,QTY
FROM #TEMPTABLE AS A
INNER JOIN (SELECT MIN(COUNT_NO) AS MIN_COUNT_NO FROM #TEMPTABLE GROUP BY VENDOR_NO) AS B
ON A.VENDOR_NO=B.VENDOR_NO
ORDER BY VENDOR_NO,COUNT_NO
DROP TABLE #TEMPTABLE
VENDOR_NO,ITEM_NO,RECIVE_DATE ,QTY
from TableName a
order by VENDOR_NO
INSERT INTO #tmp VALUES ('ID1','D1','TTTTT1')
INSERT INTO #tmp VALUES ('ID1','D1','TTTTT2')
INSERT INTO #tmp VALUES ('ID1','D1','TTTTT3')
INSERT INTO #tmp VALUES ('ID2','D2','TTTTT1')
INSERT INTO #tmp VALUES ('ID2','D2','TTTTT2')SELECT NULL as Nbr,* INTO #tmp2 From #tmp
Declare @id int
,@ID1 varchar(10)
,@ID2 varchar(10)SET @ID2=''
SET @id=0
UPDATE #tmp2 SET @id=Nbr=CASE WHEN @ID1=ID1 AND @ID2=ID2 THEN @id ELSE 0 END +1
,@ID1=CASE WHEN @ID1=ID1 THEN @ID1 ELSE ID1 END
,@ID2=CASE WHEN @ID2=ID2 THEN @ID2 ELSE ID2 ENDSELECT * From #tmp2Drop table #tmp,#tmp2另可參考:
http://www.csdn.net/expert/topic/769/769259.xml?temp=2.254665E-03
select (select count(*) from mtlrecv where VENDOR_NO=a.VENDOR_NO and RECIVE_DATE <=a.RECIVE_DATE ) as COUNT_NO,
VENDOR_NO,ITEM_NO,RECIVE_DATE ,sum(QTY)
from mtlrecv a
group by VENDOR_NO,ITEM_NO,RECIVE_DATE
order by VENDOR_NO,RECIVE_DATE---test ok