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

Mauro, I'm looking at your post right now...

Sorry, Mirko... I missed your post from way back in February...

You wrote "I don't need statistics on temp tables, because I usually know enough about their structure and data that...