Wonderful! Do you mean that you have 1.5 hours of lunch break at your work place. I envy you.

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....

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...

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...

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...

What is the language for which unicode is used for

You can use any of the two providers to connect to the Oracle database.

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...

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...

Following is a quick analogy:

Oracle SQL Server

----------------------------------------------------

PL SQL ...

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

[/url]

Also...

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...