Viewing 15 posts - 61 through 75 (of 164 total)
Nice to know! Note that you will face the same error again if, for example the value in the field 'qty'is '1234567890'. You need to define the scale and precisoin...
-----------------------------------------------------------[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]
November 8, 2008 at 3:16 am
create view text_vw (itm, sile, eqty) ...
-----------------------------------------------------------[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]
November 6, 2008 at 3:10 pm
Question 2.
I need to do what in TSQL we would call an "update from", but with derived tables, joins, etc. Sort of like this ;
Update table1
set col1 = x.colx,...
-----------------------------------------------------------[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]
September 13, 2008 at 7:34 am
In fact what I used is traditional join which is supported in MS SQL Server also while the one provided by Jitendra is ANSI Join which is used in other...
-----------------------------------------------------------[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]
September 8, 2008 at 1:37 pm
Step1: Create Table2 with columns Employeeid, Col1
Step2: insert into Table 2 values (123, 'abc1')
insert into Table 2 values (124, 'abc2')
...
-----------------------------------------------------------[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]
September 8, 2008 at 4:48 am
Same topic is discussed here
http://www.sqlservercentral.com/Forums/Topic533065-1042-1.aspx#bm533104
Regarding Unix, there is no difference in procedures whether the Oracle instance is on Unix or windows. You are dealing with the Oracle database only not...
-----------------------------------------------------------[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]
September 1, 2008 at 5:11 pm
Also check and modufy the 'Collation' property of the new table that you have added.
-----------------------------------------------------------[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 31, 2008 at 6:38 am
This is because your Excel data seems to include Unicode character.
You need to change the DefaultCodePage in your SSIS package DataFlowTask objects properties.
By default, the Code Page will be 1252,...
-----------------------------------------------------------[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 31, 2008 at 6:06 am
Pure BS 😀
Not in that league yet Paul. May be your most junior guy could qualify for it :). By the way, a developer is most akin to the...
-----------------------------------------------------------[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 29, 2008 at 6:48 am
gints.plivna (8/28/2008)
Yeahhh, then probably the problem is in terms. I won't call it backup and I won't call it restore.
PaulB (8/28/2008)
What you are doing with exp/imp is data transfer 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 29, 2008 at 3:50 am
Boomer!... how about my 154BC records comming from my twin servers in Nikaia and Antipolis?
It would be interesting to know why it was required to store these prehistoric dates...
-----------------------------------------------------------[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 28, 2008 at 1:04 pm
Yeahhh I'm not true DBA, more developer but even I know that RMAN is the way to go today.
And BTW RMAN is quite old product and has approved itself many...
-----------------------------------------------------------[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 27, 2008 at 5:36 pm
Of course the real problem is in the application. An ORDER_CREATE date cannot have happened 250 years ago! The application should not be allowing these dates but...
In your...
-----------------------------------------------------------[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 27, 2008 at 4:39 pm
Yes you are right. But it is surprising that LAST_UPDATED_DATE is not a Date field.
-----------------------------------------------------------[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 27, 2008 at 6:33 am
Try Microsoft OLEDB Provider for Oracle
-----------------------------------------------------------[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 27, 2008 at 2:46 am
Viewing 15 posts - 61 through 75 (of 164 total)