Viewing 15 posts - 76 through 90 (of 164 total)
Thanks for the very informative feedback Scott. Yes I agree with you, data or code migration from Oracle to SQL Server has to be taken very carefully and has to...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 22, 2008 at 8:45 am
Jeff Moden (8/20/2008)
Nicely done, Richard and thanks for the "cover".
Just to continue the thought, there are other ways to pull off such concatenations and some have a pitfall or two......
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 22, 2008 at 6:10 am
Hi Talib,
yeah I know that your problem was solved. I just added my comments as you asked
But again if you have any idea ...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 9, 2008 at 9:46 am
Hi Talib,
1. Take care to prefix the non-english strings with N as explained in the below link from the Microsoft support
http://support.microsoft.com/kb/239530
You must precede all Unicode strings with a prefix N...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 7, 2008 at 4:11 pm
Dear PaulB and Richards,
Both of you deserve kudos for sharing such valuable info.
Just to add my two cents:
The DTS which was part of SQL Server 2000 is now called...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 6, 2008 at 9:52 am
Dear PaulB,
Other that what's the reason you guys do not read what I write... my doubt is: what a big pile of rubbish!!! from which paralell Universe you all come...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 6, 2008 at 5:19 am
You can use DBMS_SQL package in this case.
http://download-uk.oracle.com/docs/cd/B28359_01/appdev.111/b28370/dynamic.htm
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 4, 2008 at 11:14 pm
What is the datatype in your database. Change to nvarchar if it is numeric. Also you may have to look at the language settings of your PC and the Crystal...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 4, 2008 at 12:16 am
Thanks again for your feedback on the subject. No matter what is the jargon, most important is to understand how things work and get things done.
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 3, 2008 at 11:22 am
1.
I'm sorry but I have to strongly disagree, not just me... the whole Oracle community
I wonder why to disagree when Oracle itself is defining logical backup as a valid...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 3, 2008 at 10:31 am
I think the term 'lazy' does not go in sync with the 'developer' as he is the one who has to somehow deliver the product (whatever the quality) using which...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 2, 2008 at 11:40 pm
I think logical backup and recovery using the exp and imp utilities are also very useful and important as it allows to take backup of selected objets in the schema...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 2, 2008 at 1:23 pm
Hi gints,
What I know about and use is just exporting schemas to .dmp and importing back.
Is it not the logical backup ?
Thanks,
Maz
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 2, 2008 at 4:09 am
Try to use the DTS (Data Transformation Services) if you are working with SQL Server 2000 or SSIS (SQL Server Integration Services) if you have SQL Sever 2005 or above....
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 1, 2008 at 3:08 pm
Hi PaulB,
Apart from this 'sybtax', could you share a little about the database backup methodology in Oracle. Being an Oracle developer for long in past and now SQL Server developer...
-----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]
August 1, 2008 at 2:56 pm
Viewing 15 posts - 76 through 90 (of 164 total)