16,017,502 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by FranklinRemo (Top 14 by date)
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.
Show More