我想把“SELECT
Users.UserName,
OverTimeHead.OverTimeHeadId,
OverTimeList.OverTimeListId,
OverTimeHead.OrgName,
OverTimeList.StartDateTime,
OverTimeList.EndDateTime,
OverTimeList.ActualWorkingHours
FROM OverTimeList
INNER JOIN Users ON OverTimeList.PK_User = Users.PK_User INNER JOIN OverTimeHead ON OverTimeList.OverTimeHead =OverTimeHead.OverTimeHeadId”
先出来的值插入到另一个表中(不是新建)
Users.UserName,
OverTimeHead.OverTimeHeadId,
OverTimeList.OverTimeListId,
OverTimeHead.OrgName,
OverTimeList.StartDateTime,
OverTimeList.EndDateTime,
OverTimeList.ActualWorkingHours
FROM OverTimeList
INNER JOIN Users ON OverTimeList.PK_User = Users.PK_User INNER JOIN OverTimeHead ON OverTimeList.OverTimeHead =OverTimeHead.OverTimeHeadId”
先出来的值插入到另一个表中(不是新建)
解决方案 »
- silverlight里datagrid动态绑定数据怎样展示
- ASP.NET自定义控件
- C#中用dateTimePicker1.Value.Date问题...急
- 关于cookie生存期的问题,求教.
- 只能允许查看文件,不能保存和打印,如何实现?
- 新手问个初级问题:建立c/s架构服务器端,是新建个windows服务还是控制台应用程序?
- 发布代码啦,c#实现的打印DataGrid中的数据--可分页[原创]
- 为什么listbox没有被清除?【初级问题】
- winform调试问题??
- 文本数据批量导入导出数据库功能~~急~~
- 正则表达式?(c#)
- 关于IAsyncResult强制转换为AsyncResult
select f,........from
SELECT
Users.UserName,
OverTimeHead.OverTimeHeadId,
OverTimeList.OverTimeListId,
OverTimeHead.OrgName,
OverTimeList.StartDateTime,
OverTimeList.EndDateTime,
OverTimeList.ActualWorkingHours
FROM OverTimeList
INNER JOIN Users ON OverTimeList.PK_User = Users.PK_User INNER JOIN OverTimeHead ON OverTimeList.OverTimeHead =OverTimeHead.OverTimeHeadId”
INSERT INTO OverTimePay (Multiple, OverTimeListId, UserName, OrgName, StartDateTime, EndDateTime, ActualWorkingHours)
SELECT '1.5' AS Expr1, OverTimeList.OverTimeListId, Users.UserName, OverTimeHead.OrgName, OverTimeList.StartDateTime, OverTimeList.EndDateTime, OverTimeList.ActualWorkingHours
FROM OverTimeList INNER JOIN Users ON OverTimeList.PK_User = Users.PK_User CROSS JOIN OverTimeHead
INSERT INTO OverTimePay
(Multiple, OverTimeListId, UserName, OrgName)
SELECT '1.5' AS Expr1, OverTimeList.OverTimeListId, Users.UserName
FROM OverTimeList INNER JOIN
Users ON OverTimeList.PK_User = Users.PK_User CROSS JOIN
OverTimeHead
我执行后,会反复不断的插入,应该只有3条的,居然插入了160条,急啊!