Comments by FranklinRemo

FranklinRemo 21-Jan-13 0:40am View

thank you tharaka , that is only problem here , if i know "How do you took the start date and end date for wbs_id = 1000?" then i will not post this issue here.

FranklinRemo 21-Jan-13 0:39am View

it will not help ful because alredy i tried it. this requirement will full fill only with WITH CTE.

FranklinRemo 20-Jan-13 7:12am View

first take the above script and try what i mentioned in output. then let you know what you need to do .
that's y i clearly mentioned required output with tables script.
then what clarification you need .

FranklinRemo 20-Jan-13 7:08am View

Deleted

first take the above script and try what i mentioned in output. then let you know what you need to do

FranklinRemo 16-Jan-13 7:30am View

already i have seen this one but i am not able to implement it

FranklinRemo 3-Jan-13 2:09am View

Hi it is giving the same error i.e ORA -00936 Missing Expression.
my column name is payment only then how could you specify [payment number].if i write payment also it is giving same error

FranklinRemo 3-Jan-13 1:46am View

Hi RDBurmon , thank you for reply.

it is showing the error like 0RA-00936 Missing Expression

FranklinRemo 2-Jan-13 3:41am View

Hi _TR_21K ,
actually i have mention table structure also . kindly check it once and share your ideas

FranklinRemo 31-Dec-12 6:57am View

Kalyan ,
i know this , but the actual reason before posting this question is ,
our report url is asking username and password for opera , firefox and safari etc.. browsers.
so to fix this issue we have to fix the browser in URL itself.because out client sholudn't accept the above issue to over come this we should fix browser in url itself

FranklinRemo 30-Dec-12 6:07am View

db7uk thank you for your cooperation.
i resolve this issue by storing functions result into physcial table now my procedure is running with in 00 seconds only

FranklinRemo 28-Dec-12 23:47pm View

db7uk , because of those scalar function my procedure taking more time to execute.i eliminated function and implemented same functionality with normal select statement but it is not giving proper result for a procedure but procedure is exectuing with in 5 seconds with un-appropriate data

FranklinRemo 28-Dec-12 23:40pm View

Thank you db7uk , i verified all tables indexes which are used in where clause conditions all are having indexes.now i am not able to change the above query to cte, if possible can you change the above code

FranklinRemo 7-Dec-12 10:32am View

but it is displaying like below i.e error message have to be display in separate line

Job Started - Dec 7 2012 8:49PM
job ended at Dec 7 2012 8:49PM
Error Message SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "192.168.6.38.CMSREPORTDB.tuqa" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

FranklinRemo 7-Dec-12 10:31am View

Kuthuparakkal ,

its working fine but my requirement is
Job Started - 2012-11-27 13:35:23.000
Job Ended - 2012-11-27 13:35:23.000
Error Message:
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager
"localhost" failed with error code 0xC0202009.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Comments by FranklinRemo (Top 14 by date)