This is the code that was causing us problems this morning:

insert into account_revenue

(

Account_id,

balance_date,

revenue_type_code,

no_of_trans,

discount_value,

revenue_at_standard_tariff,

actual_revenue,

ytd_actual_revenue,

revenue_ccy_id,

ytd_discount_value,

ytd_revenue_at_standard_tariff,

ytd_revenue_ccy_id,

revenue_type_def_id,

input_batchid

)

select

previous_month.uni_account_id,

@current_processing_date,

previous_month.uni_revenue_type,

0 as no_of_trans,

0 as discount_value,

0 as revenue_at_standard_tariff,

0 as actual_revenue,

case when datepart(month,@current_processing_date)= 1 --If JANUARY then YTD Revenue...

Update.

I have split a proc with 6 steps into individual procs and still getting similar problems. However, if I copy the sql statement out the offending proc and execute...

Does the batch job run correctly? Can you execute the batch job from a dos window/command line? If there are any problems and it reports an error it...

Personally, I would go for a parent/child design:

declare @parentchild table

( child varchar(25)

, parent varchar(25)

)

-- Top level

insert @parentchild select 'paper', null

insert @parentchild select 'cardboard', null

insert @parentchild select 'vinyl', null

insert @parentchild select...

If you are really desparate to avoid the <> operator you could try this:

declare @exclusion table

(salary money)

insert @exclusion select 0

select columname

from table t1

left outer join @exclusion t2

on t1.salary = t2.salaray

where...

John,

Might the problem be that the format file does not exist on your PC rather than the file you are trying to load? The format file is explicitly identified...

I created a DTS package that opened notepad and the package only completed when I closed notepad. Is this the same as your situation?

If so then when you schedule...

Have you got the same index in 2000 as in 2005? If not then SQL Server will randomize the rows and give a different checksum result.

Jez

It's a few years since I did this (and my memory might be failing me) but I worked on a project where we stored Excel files within the database and...

David,

If you want to pass an optional parameter then try this:

create procedure TEST @EmployeeId int = null

SELECT * FROM Employees

WHERE EmployeeID = isNull(@Employee, EmployeeID)

go

-- exec TEST 5 ...

Having got the result into a global variable, you will need to use an ActiveX script to interrogate the value of the global variable and then enable or disable the...

Sometimes SQL Server gets mixed up with the amount of space reserved for a table but not used - unused space.

This is a script I found on this site...

As you said in your original post, these are not the same dimension - one is SigningDate and the other is ExpirationDate. Yes they might both contain dates but...

Can you provide a bit more information such as is this error from a client application or a batch process?

Jez

Whenever I have used role playing dimensions, I have had a layer of separation between the dimension table and the cube using a view.

Is this a possibility in your situation...