Viewing 15 posts - 826 through 840 (of 2,062 total)
July 3, 2012 at 11:18 am
Depends on selectivity (most distinct values goes) and the number of rows returned
WHERE clauses like Date BETWEEN a And B and Database = 'X'.
Assuming the most popular query relies on...
July 3, 2012 at 4:28 am
You'll have to check the NLS-settings of the database[/url]
In the earlier days in compares to varchar, but now the database can be fully in unicode so that varchar2 is also...
July 2, 2012 at 12:16 pm
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
Viewing 15 posts - 826 through 840 (of 2,062 total)