大力可是sql板的顶级高手,你跑这里来问,他看的到才怪
解决方案 »
- Microsoft.Office.Interop.Excel
- 关于获取数据库数据的问题
- ~~~~~~请问SqlBulkCopy有Update功能吗?我在MSDN里没有找到
- liu2835993 给您补个分
- 用 ajaxpro method 实现文件下载
- 点击母板中的链接能实现母板不刷新,页面刷新吗
- 各位大侠帮忙,怎么去下面的一段字符中制定的值
- 求救,对各位哥们应该是个不是问题的问题(一个设置问题)。
- **高分求助!!帮我看看下面这段代码,是关于alert的,谢谢!!
- 怎样移动服务器端的文件并保存到数据库?求指点一下
- datagrid动态改变一行的背景色this.DataGrid1.Items[oldselectindex].backcolor=System.Drawing.Color.Red;为什么不工作啊?
- 一个有点难度的DataGrid问题
min(t1) as t1,
min(t2) as t2,
min(t3) as t3,
min(t4) as t4
from (
select empid,empno,kqdate,
case when (select count(*) from c where empid=x.empid and empno=x.empno and kqdate=x.kqdate and kqtime<=x.kqtime)=1 then kqdate+' '+kqtime end as t1,
case when (select count(*) from c where empid=x.empid and empno=x.empno and kqdate=x.kqdate and kqtime<=x.kqtime)=2 then kqdate+' '+kqtime end as t2,
case when (select count(*) from c where empid=x.empid and empno=x.empno and kqdate=x.kqdate and kqtime<=x.kqtime)=3 then kqdate+' '+kqtime end as t3,
case when (select count(*) from c where empid=x.empid and empno=x.empno and kqdate=x.kqdate and kqtime<=x.kqtime)=4 then kqdate+' '+kqtime end as t4
from c x
) as y
group by empid,empno,kqdate
order by empid,empno,kqdate
go