Viewing 15 posts - 16 through 30 (of 164 total)
UTF8 CHARACTERSET has known issue with import. I have used AR8MSWIN1256 without problem for Arabic data. You can also try AL16UTF16. The SQL Server coalation you are using is perfect.
-----------------------------------------------------------[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 2, 2009 at 10:30 pm
millerfw (10/31/2009)
-----------------------------------------------------------[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]
October 31, 2009 at 5:51 am
newbieuser (10/22/2009)
SELECT Q.*, p.pmtco, p.pmtno, p.pmtbk, p.pmtrcn, p.pmtamt
FROM qtral Q left outer join pymt p on...
-----------------------------------------------------------[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]
October 25, 2009 at 5:17 am
Jeff Moden (9/24/2009)
I get it... you're not running the same code as in the article. Please post the code you are running. Thanks.
You are right Jeff. The code...
-----------------------------------------------------------[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 25, 2009 at 3:50 am
Jeff Moden (7/26/2009)
1. We don't need RBAR to do this... no WHILE loops please. :sick:
2. We don't need 8 functions to do this... that's a lot...
-----------------------------------------------------------[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 24, 2009 at 9:07 am
PaulB (9/13/2009)
Mazharuddin Ehsan (9/11/2009)
-----------------------------------------------------------[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 14, 2009 at 10:07 am
Paul White (9/11/2009)
The code INSERT INTO @Employees SELECT Emp_No...
-----------------------------------------------------------[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 11, 2009 at 10:27 am
Your solution there relies on IDENTITY values being assigned in the same 'order' as the query processor inserts the rows. Before SQL 2005, the assignment order was not defined even...
-----------------------------------------------------------[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 11, 2009 at 5:01 am
PaulB (9/10/2009)
Mazharuddin Ehsan (9/9/2009)
PaulB (9/9/2009)
Please note that it doesn't work as OP expected to work in Oracle
It is for the OP to tell us what he intends to do...
-----------------------------------------------------------[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 10, 2009 at 11:37 am
.
-----------------------------------------------------------[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 10, 2009 at 11:26 am
Bruce W Cassidy (9/9/2009)
-----------------------------------------------------------[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 10, 2009 at 11:03 am
PaulB (9/9/2009)
Please note that it doesn't work as OP expected to work in Oracle
It is for the OP to tell us what he intends to do with the rownum....
-----------------------------------------------------------[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 9, 2009 at 3:54 pm
In this specific case OP was relying on rownum to get "ordered" rows from a table which would never happen.
Here is one way to make it happen in SQL Server...
-----------------------------------------------------------[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 9, 2009 at 1:02 pm
It worked fine for me for the task as follows. The Phone numbers in a table in two fields as shown in the below example was required to be changed...
-----------------------------------------------------------[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 11, 2009 at 4:26 am
Senthil Kumar Rajendran (7/23/2009)
i got an error on this... can you just me to rectify this error...
TITLE: SQL Server Import...
-----------------------------------------------------------[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]
July 26, 2009 at 4:21 am
Viewing 15 posts - 16 through 30 (of 164 total)