For that query, we will need a calendar table with a search condition like...

Senthil,

Joe is absolutely correct about...

Using Noeld's example, the EXEC statement might look like this...

EXEC (@str1+@Str2)

Yeah... I know about xp_executeSQL...

Ok... let's hope Business Objects has a cross-tab function

 If it doesn't, post back 'cause...

I guess that means you may have more or less than the 4 parts you mentioned in your first post, eh?

Ok... let's hope Business Objects has a cross-tab function (or not,...

Thanks for the compliment but I'm no God of SQL ... even after 11 years with SQL Server, I still make some really...

Dionisis,

I'd say your function has a bit of a bug in it...

SELECT dbo.fn_GetNumber('123-456')

It choked on that pretty hard, I'd say.  The problem is that ISNUMERIC allows the "+", "-",...

>>Thank you for your input. parse name does not work because the values are not as concistent as we want to have

Ummm... post some real data and let us...

If I may make an additional suggestion... it is not necessary to store the data in a Duration column... you could simply make a calculated column consisting of the the...

Steven,

See the post that "SQL Junky" directed you to... the bottom line is ISNUMERIC is not an ISALLDIGITS function... ISNUMERIC allows all sorts of "garbage" in...

Your CASE statement should be...

Using your current table structure, you could do this...

 INSERT LogTime (EmployeeID, CompanyID, LogIn, LogOut,

        DaysTotal,HoursTotal,MinutesTotal,SecondsTotal)

 SELECT @EmployeeID, @CompanyID, @login, @Logout,

        DaysTotal    = X.Sec / (24 * 60 * 60),

       ...

This should do it...

USE [DashboardSQL-2K5]

GO

DECLARE @return_value int

EXEC @return_value = [dbo].[spWTRalldatareportsummary]

  @dt_src_date = CONVERT(DATETIME,N'28/04/2006',103),

  @chr_div = NULL,

  @vch_portfolio_no = NULL,

  @vch_prop_cat =...

P.S. Using the Linked Server method would keep you from exposing server logins in code, anywhere.

Thanks Hector,

Gift Peddie posted a solution we use at work... Proxy Accounts work great for this.

The other thing you could do is to create a linked server for the other...

Sorry I'm late...

I guess you should call it RBAR since you absolutely need to read a row at a time... I'd be tempted to call it a control loop because...