You will need to build the whole process dynamically including the cursor work.

This is what I see as your option.

Note: This is one of the few times you will see me use a cursor.

Replace tbl_Name with the name of your table.

------------------------------------Code Begins--------------------------------------------------------

SET NOCOUNT...

After reading your statement and the code I can see immediately we don't have enough of the picutre to know for sure what is going on. Can you post the...

However if you are needing data from DB2 that is not being joined to data on the SQL Server I suggest using a direct connection to the DB2 server as...

On the machine you are editing it on is the path valid? When executed it will be executed by the job on the calling server. But say you have going...

Then it would be a simple matter of a trigger each time the value is updated. Or better get rid of the column and make a view with that column...

Ok, first thing I know I would do thou at this point is factor down to a common element on the estimatedduration column.

Since so far your smallest unit is 6...

Ok this is where you confuse me.

"Allocate 2 days spend two days and the % figure would be 70."

If a allocate 2 and spend 2 days then how am I...

Next what does 1 day represent? 24hrs? And are you just taking the sum of time for all start and stop times to calculate the values? Your comments and sample...

Your drivers may not expose the proer info for the Ole drivers to work with. Check out this link http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlole.mspx . Note also not all drivers will work with SQL...

Based on the sampling you provided this is how I would do it.

SELECT

 A.[Date],

 A.Car,

 A.Type,

 A.[Count] - C.[Count]

FROM

 auto_stock A

INNER JOIN

 (

  select

   max([date]) [Date],

   Car,

   Type

  from

   auto_stock

  Group By

   Car,

   Type

  ) B

On

 A.[Date] = B.[Date] AND

 A.Car = B.Car AND

 A.Type =...

You will only be able to use dynamic sql to use that method (which for your needs will be the best). I suggest looking at the data on the other...

but you won't you will get nulls for the other columns and since you have multiple servers you cannot use max or other aggregate to group it. Your going to...

Try

sp_msforeachdb '

print ''?''

SELECT FILEPROPERTY(''?_Log'', ''SPACEUSED'')'

as long as all are dbname_log will work otherwise will get nulls for those not.

Actually look at the Agent properties itself in EM. On the last tab there is a connection item. By default it is Windows Auth make sure is still that way.