 |
|
Code (SQL)
INSERT INTO manpower_temp_log (
id_mp_temp,
[year],
total,
month1,
month2,
month3,
month4,
month5,
month6,
month7,
month8,
month9,
month10,
month11,
month12,
status,
created_id,
created_date
) SELECT
DISTINCT
id_mp_temp,
[year],
total,
month1,
month2,
month3,
month4,
month5,
month6,
month7,
month8,
month9,
month10,
month11,
month12,
status,
created_id,
created_date
FROM
inserted
insert จาก Table1 แล้วให้ trigger insert ลง table2 มันเบิ้ลทุก record เลยครับ
Tag : .NET
|
|
|
 |
 |
 |
 |
| Date :
2017-06-07 17:09:38 |
By :
kenghockey |
View :
836 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
|
 |
