I don't have experience with powerdesigner. Perhaps you can contact the vendor?

What are CDM and PDM ?

you can accomplish that with the case statement

,case

WHEN gldebitacct IS NOT NULL THEN

     CASE

           WHEN ...

You must be aware that you'll have to reconfigure microsoft transaction coordinator.

See: http://support.microsoft.com/kb/839279

Otherwise I've had no issues.

according to the books online sql 2000 gives

Transaction (Process ID %d) was deadlocked on {%Z} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

perhaps...

Select the job(s) you want from Management-SQL Agent-Jobs  in enterprise manager

Right click and choose all tasks->Generate script

If it was a long running query it may have an extensive rollback period.

Are there any entries in the OS event-viewer?

Can you connect to the database using queryanalyzer? If so...

Which indexes are currently used by your query (view the queryanalyzer)?

Does the index wizard gives any hints?

select

It could have been that the server was too busy.

Is the user able to open the report now?

A lot of sums

Are there indexes on Population.Postcode, Postcode_boundary.Postcode?

Depending on the uniqueness of B.CD_CODE , is there an index on Postcode_boundary.CD_CODE?

Are the statistics...

if 06/30/3003 was a typo

and date_range in the lookup table is split in 2 fields

it can be something like this

select trans_key.key_id,trans_date,Moneyfield,keylookup.good_key as corrected_key

from test.dbo.trans_key trans_key /*transaction table*/

inner join test.dbo.keylookup keylookup...

not sure if  (t1.statusid > @newstatus  or t1.statusid < @newstatus) performs better.

What are your current indexes?

Is the sql reporting server on the same server as your IIS/SQL server?

The reporting was working fine->what has changed? (Moved from development to production....?)

cheers!

Can you connect to the database using the connectionstring the application uses? (using query analyzer)

database logon failed

Is the application using windows authentication or sql authentication to connect to sql server?