Viewing 13 posts - 151 through 164 (of 164 total)
Check your browser settings:
Tools -> InternetOptions -> Security -> Custom Level -> Make the User Authentication as Anonymous Login
-----------------------------------------------------------[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]
December 29, 2007 at 5:17 pm
Wonderful! Do you mean that you have 1.5 hours of lunch break at your work place. I envy you.
-----------------------------------------------------------[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]
December 29, 2007 at 8:07 am
Clearly it is a logical error. At least your code is free from any syntax error. Check carefully. My original program deducts 0.5 hours for the lunch period each day....
-----------------------------------------------------------[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]
December 28, 2007 at 9:07 am
Incidently, I am also using this solutuion to calculate and report the duration passed for the unresolved IT HelpDesk cases at my work place. The results are displayed on an...
-----------------------------------------------------------[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]
December 28, 2007 at 5:26 am
We are supporting SQL Server installations which has databases with non English data.
Our practice is to keep the server and database collation as SQL_Latin1_General_CP1_CI_AS
On the object level we use nvarchar...
-----------------------------------------------------------[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]
December 26, 2007 at 11:55 am
You can query theReportServer database for this information as follows:
SELECT
ex.UserName, ex.Format, ex.TimeStart, cat.Name,
ex.Parameters,
CONVERT(nvarchar(10), ex.TimeStart, 101) AS rundate
FROM ExecutionLog AS ex, Catalog AS cat
where ex.ReportID = cat.ItemID
ORDER BY ex.TimeStart...
-----------------------------------------------------------[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]
December 26, 2007 at 9:45 am
What is the language for which unicode is used for
-----------------------------------------------------------[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]
December 26, 2007 at 9:07 am
You can use any of the two providers to connect to the Oracle database.
-----------------------------------------------------------[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]
December 24, 2007 at 5:12 am
You can use the SQL Server Import Export wizard to create a SSIS package as follows then build upon it using the 'SQL Server Business Intelligence Development Studio'
1. Open SQL...
-----------------------------------------------------------[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]
December 23, 2007 at 2:19 pm
The equivalent of Oracle Portal from Microsoft is
SharePoint Server
I would like to clarify at this point that SharePoint Server is not exactly
the equivalent tool of Oracle Portal in SQL...
-----------------------------------------------------------[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]
December 21, 2007 at 6:16 am
Following is a quick analogy:
Oracle SQL Server
----------------------------------------------------
PL SQL ...
-----------------------------------------------------------[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]
December 20, 2007 at 2:32 pm
Hi Venki,
It is my great pleasure to know that the script is helpful for your requirements. Please post your progress and/or difficulties if any to this forum or at
Also...
-----------------------------------------------------------[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 29, 2007 at 4:26 am
Hi Venki,
Here is the answer to your problem.
http://www.sqlservercentral.com/scripts/Scalar-valued+Functions/61567/
As I understand from your description, you need to do the following modifications to get what you exactly need.
1. The function CalcTimeSinceCreated...
-----------------------------------------------------------[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 27, 2007 at 9:39 am
Viewing 13 posts - 151 through 164 (of 164 total)