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

Hi Toni,

Could you post the current code you are using that is coughing up the aborant data, please?

Beat me to it, Conway... absolutely correct.

From the main screen, click on [Resources][Discussion Forums].  You will be taken to a screen with different forums.  The T-SQL forum seems to be the most popular but take the...

Something like this, I would imagine...

 SELECT (--Finds count of ALL distinct machine names in the table

         SELECT COUNT(DISTINCT MachineName)

           FROM yourtable

        )

      - (--Finds count of distinct machine...

Absolutely!

Hector,

What does the stored proc do with the command shell?  There might be some better ways to do things without have to use command shell...

Just an alternative to Pam's good code...

WHERE   DATEDIFF(mm,0,src_terrier.datadate) = DATEDIFF(mm,0,@dt_src_date)

AND

    (src_terrier.Areacode = @chr_div) AND

    (src_centre_list.Portfolio_no = @vch_portfolio_no) AND

    (src_centre_list.propcat = @vch_prop_cat) AND

    (src_tbl_rental.site_ref = src_terrier.siteref)

Mauro,

Just trying to clarify... are you saying that each row of the QueryDescription column contains the code for a complete query and that you want to execute all of them...