Viewing 15 posts - 811 through 825 (of 2,044 total)
Did you also check "In Process" option? (should be enabled)
June 30, 2012 at 6:24 am
Answer: join mysummedhours with T_DM_HUMAN_RESOURCES
select mysummedhours.F_EMPLID, mysummedhours.Wk_Reported,summedworkhours
,T_DM_HUMAN_RESOURCES.F_RESOURCE_MGR_NAME
from
(
SELECT LP.F_EMPLID,to_char(LP.F_WK_END_DT, 'WW') Wk_Reported ,SUM( LP.F_CCSI_WORK_HRS) summedworkhours
from DW.T_DM_LABOR_PAYTIME LP
WHERE EXISTS (SELECT 1 FROM DW.T_DM_HUMAN_RESOURCES HR WHERE LP.F_EMPLID=T_DM_HUMAN_RESOURCES.F_RESOURCE_ID)
GROUP BY LP.F_EMPLID,to_char(LP.F_WK_END_DT, 'WW')
) mysummedhours
INNER JOIN
DW.T_DM_HUMAN_RESOURCES...
June 18, 2012 at 5:14 pm
Grouped by LP.F_EMPLID and Wk_Reported
select mysummedhours.F_EMPLID, mysummedhours.Wk_Reported,summedworkhours
from
(
SELECT LP.F_EMPLID,to_char(LP.F_WK_END_DT, 'WW') Wk_Reported ,SUM( LP.F_CCSI_WORK_HRS) summedworkhours
from DW.T_DM_LABOR_PAYTIME LP
WHERE EXISTS (SELECT 1 FROM DW.T_DM_HUMAN_RESOURCES HR WHERE LP.F_EMPLID=T_DM_HUMAN_RESOURCES.F_RESOURCE_ID)
GROUP BY LP.F_EMPLID,to_char(LP.F_WK_END_DT, 'WW')
) mysummedhours
June 15, 2012 at 4:23 pm
Glad it works now, what have you done to make it work?
June 15, 2012 at 1:28 pm
Maybe it is related to oracle oledb fetchsize (default 100) OraOLEDB-Specific Connection String Attributes for Rowsets
June 14, 2012 at 8:28 am
Maybe it is related to oracle oledb fetchsize (default 100) OraOLEDB-Specific Connection String Attributes for Rowsets
June 14, 2012 at 8:28 am
There are more people having the issue like psubrama2000 who found a workaround workaround at the end.
What oracle driver/what version does the linked server use?
June 14, 2012 at 8:24 am
Or you could use heavy duty material to remove the tree (bulldozer, tractors, chainsaws...). The options keep growing.
June 14, 2012 at 8:09 am
Payback for my excellend sql server teacher and others on this forum.
June 13, 2012 at 1:46 pm
I have no experience with SSIS but would leave a minimum of 2 GB for the OS/other applications (max memory<6 GB).
Have a look at
June 7, 2012 at 4:03 pm
As an accidental Oracle dba myself (coming from sql server 2000) I've found the Oracle concepts most interesting to grasp what the main differences are.
After that backup/restore (rman, needs...
June 6, 2012 at 3:06 pm
if it is an index, you could try to drop it and rebuild
June 6, 2012 at 2:00 pm
Maybe we will wait until Release 2 comes out. By the time it is well established.
June 6, 2012 at 10:18 am
May 15, 2012 at 10:00 am
Viewing 15 posts - 811 through 825 (of 2,044 total)